List:General Discussion« Previous MessageNext Message »
From:John Hoskins Date:February 26 2003 7:22pm
Subject:select help
View as plain text  
Probably a simple query but, I need to find select a field with data that 
exists in one table but does not exist in a field in another table.

example:

table1.name			table2.name
-----------			------------
bob				john
susan				jane
tom				tom
john				bob
jane				john
				jane
				tom


result should be = susan

any help is appreciated

-JH

Thread
select helpJohn Hoskins26 Feb
  • RE: select helpDon Read26 Feb