[SQL] Related table question

[Eric Forget]

>> Then I get
>> 
>>       RecID
>>   1   1
>>   1   1
>>   2   2 
>>   3   3
>   ^^^^^^^^^^^^^^ why 2 columns if you SELECT A.RecID only.

Sorry, the first column is the fixed column of VStudio.
 
>> Which is not what I want!
> 
> Btw, please show what you WANT to get from above 2 tables?

    A.RecID
    1
    2

I know I'm missing the DISTINCT, but I thought it was outside the dicussion.

Eric

___________________________________________________________________

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

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