Re: 4gl mods (for Jon)

> Add these to your list: > > a) > select key1, key2 > from table1 > where <key1, key2> not in > (select key1, key2 from table2)> > i.e. doing a exclusive select based on a composite key. Not a good idea. Involves a fundamental change to SQL. Only the ANSI committee can do that. > of course there's probably a way to do this that I can't think of. Yep. No worries mate. Try this: select key1, key2 from table1 where not exists ( select * from table2 where table1.key1 = table2.key1 and table1.key2 = table2.key2 ) -- David Stockel Internet: stockel@snide.com of ADIA Information Technologies