Hi,

An SQL problem!

I have 3 tables: PROJECT, AUTHORS and KEYWORDS

One Project have various AUTHORS and various KEYWORDS, this two
tables have the fields PRCODE, with the code of their Projects.

I want to do a select that retrieves:

One Record containing: PROJECT CODE, PROJECT TITLE, the first
AUTHOR.
This search can be made on fields: AUTHOR, TITLE or KEYWORDS

That is my "select":

SELECT A.CODE, A.TITLE, B.NAME, C.WORD from PROJECT A, AUTHORS B,
KEYWORDS C
WHERE (B.NAME like %AnyString% or C.WORD like %AnyString% or
A.TITLE like %AnyString%)
AND B.PRCODE = A.CODE
AND C.PRCODE = A.CODE

Example of the select above.
For a project with 2 authors and 3 keywords this is returning:

1 The-Project-Title First-Author First-Keyword
1 The-Project-Title Second-Author First-Keyword
1 The-Project-Title First-Author Second-Keyword
1 The-Project-Title Second-Author Second-Keyword
1 The-Project-Title First-Author Third-Keyword
1 The-Project-Title Second-Author Third-Keyword


Why can I made a SELECT that retrieves one RECORD, containint the
first author and first keyword only?

Thanks a lot

Moacir