What do I have to do a query where information in table1 is not in table2
I am looking for something like
Select table1.firstname where table1.firstname is not in table2.firstname
and table2.date='yesterday'
I tried
Select table1.firstname where table1.firstname != table2.firstname and
table2
Hi Brian,
Try something like this:
SELECT firstname FROM table1 WHERE firstname NOT IN (SELECT firstname
FROM table2 WHERE table2.date='yesterday'::date);
Hope this helps.
Francis Solomon
>
> What do I have to do a query where information in table1 is
> not in table2
>
> I am looking for some
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'
