SQL Question

[Eric Forget]

> on 2/8/03 11:22 PM, Eric Forget at forgete at cafederic.com wrote:
> 
>> Hi,
>> 
>> Imagine I have 3 tables in M:M relation: A, B and AB. Now I would like to
>> have all the A which have at least 1 relation to it. Is it possible with
>> SQL?
> 
> Hi Eric,
> 
> You need get RecIDs of A, yes?
> 
> You need ask for this just AB table by this simple query:
> 
>   SELECT DISTINCT ptr_a
>   FROM AB
> 

Thanks Ruslan, that's exactly what I was looking for...

Éric

___________________________________________________________________

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

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