[RBG7-L] - Re: View where key in table1 does not exisit in table2

[Lawrence Lustig]

> 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