ProFox :: Re: SELECT-Sql IN clause help

Subject:	Re: SELECT-Sql IN clause help
Author:	"Alan Bourke"
Posted:	2006/11/30 11:40:36

View Entire Thread

New Search

Ta, this also works:

SELECT ref FROM table1 WHERE NOT EXISTS (SELECT ref FROM table2 WHERE
table2.ref=table1.ref)

--
Alan Bourke
alanpbourke /AT/ fastmail .DOT fm

--
http://www.fastmail.fm - mmm... Fastmail...

©2006 Alan Bourke

<-- Prior Message

New Search

Next Message -->