SQL: how to find values NOT in a table

Posted in 1998

Axel Sander — Thu, 10 Dec 1998 18:23:08 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, I'm trying to find a solution for the following problem: I have 2 tables 'table1' and 'table2' each having the columns 'flag' and 'value'. 'flag' could be duplicate and 'value' too, only the combination of both is unique. table1 contains all the data, table2 only a subset. How do I find the rows in table1 which are *not* contained in table2? (I'm still using an SE 5.2) Axel