You could try:

SELECT * FROM A WHERE A_PK1 NOT IN (SELECT YOURCOLUMN FROM B)


Best Regards
Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

"Bert Neef" <bert@...> schrieb im Newsbeitrag
news:4.3.2.7.2.20020211211149.03b4f078@localhost...

> return a selection of rows from table A based on wether the value of the
> primary key of a row isn't found in a certain column in table B. (or is
> found)? if yes : how?
>
> Thanks in advance,
>
> Bert Neef
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>