[SQL] Related table question

[Ruslan Zasukhin]

on 1/15/04 9:48 PM, 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:


Table A  { a1 }
    
    1
    2
    3

Table B { ptr ,b1 }

    1   1
    1   2
    1   3
    2   1
    2   2



And now you do simply:

    SELECT DISTINCT ptr
    FROM B



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