can't figure out sql query

Robert Brenstein rjb at robelko.com
Wed May 3 11:40:29 CDT 2006


>Sounds like query with EXCEPT
>
>May be you can get it using
>
>WHERE
>     RecID NOT IN
>         (select A.RecID FROM T1, T2 WHERE T1.id = T2.ptr )
>And
>     RecID NOT IN
>         (select A.RecID FROM T1, T3 WHERE T1.id = T3.ptr )
>
>Not sure how effective this will be.
>

Thanks a bunch, Ruslan. It works.


More information about the Valentina mailing list