[SQL] Related table question

[Eric Forget]

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

Eric

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>

 Fingerprint <86D5 38F5 E1FD 5D9C 71C3  BAA3 797E 70A4 6210 C684>