January 6, 2012

Find Records not in another table


SELECT * FROM   CallLEFT OUTER JOIN Phone_Book
  ON (Call.phone_number = Phone_book.phone_number)
  WHERE Phone_book.phone_number IS NULL

No comments:

Post a Comment