[SQL] Related table question

[Ruslan Zasukhin]

on 1/15/04 6:47 PM, Eric Forget at forgete at cafederic.com wrote:

>> You need to use LEFT OUTER JOIN
>> 
>> SELECT DISTINCT Table1.RecID
>> FROM Table1, Keyword
>> WHERE   Table1.RecID *= Keyword.mTable1 AND
>>           Keyword.Name <> 'me'
> 
> This almost works. If I change it to something like:
> 
> SELECT DISTINCT Table1.RecID, Table1.Name
> FROM Table1, Keyword
> WHERE   Table1.RecID *= Keyword.mTable1 AND
>          Keyword.Name <> 'me'
> 
> Or 
> 
> SELECT DISTINCT Table1.RecID
> FROM Table1, Keyword
> WHERE   Table1.RecID *= Keyword.mTable1 AND
>          Keyword.Name <> 'me'
> ORDER BY Table1.Name
> 
> Then all the records are returned. It looks like the "Keyword.Name <> 'me'"
> is unused. Is it normal?

Do you get result records with 'me' ?

Not sure if this is correct


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------