[SQL] Related table question

[Ruslan Zasukhin]

on 1/16/04 1:49 AM, Eric Forget at forgete at cafederic.com wrote:

>>>> Btw, please show what you WANT to get from above 2 tables?
>>> 
>>>   A.RecID
>>>   1
>>>   2
>> 
>> This is what you need?
>> 
>> 
>> -----------------------------
>> Then I offer you simplest way:
> 
> Seriously... ;-)
> 
> This is the result I want with the dataset you provided. But I need to get
> it with "B.b1 <> 1". This is what the user provided.

Then also simply:

    SELECT DISTINCT ptr
    FROM B
    WHERE b1 <> 1


TIP is you can get this info from single B table.
No need to build JOIN

-- 
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
-------------------------------------------------------------