Hello Brian,
Wednesday, December 27, 2000, 9:20:53 PM, you wrote:
BCD> What do I have to do a query where information in table1 is not in table2
BCD> I am looking for something like
BCD> Select table1.firstname where table1.firstname is not in table2.firstname
BCD> and table2.date='yesterday'
BCD> I tried
BCD> Select table1.firstname where table1.firstname != table2.firstname and
BCD> table2.date='yesterday'
BCD> and that did not work just listed everyone....
If I understand correctly
Select table1.firstname from table1 where not exists
(select table2.firstname from table2 where table1.firstname = table2.firstname and
table2.date='yesterday')
--
Best regards,Yury mailto:yura@vpcit.ru