SQL Question

[Ruslan Zasukhin]

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


-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------