I should have known that!....
Lawrence Lustig <[EMAIL PROTECTED]> Sent by: [email protected] 06/06/2005 10:02 PM Please respond to [email protected] To [email protected] (RBG7-L Mailing List) cc Subject [RBG7-L] - Re: View where key in table1 does not exisit in table2 > I need to build a view where the values in table 'phone' do not exist in > table2 'phone'. Either: SELECT * FROM Table1 WHERE phone NOT IN (SELECT DISTINCT phone FROM Table2) or SELECT * FROM Table1 WHERE NOT EXISTS + (SELECT * FROM Table2 WHERE Table2.Phone = Table1.Phone) -- Larry
