[SQL] Query Help

[Brian C. Doyle]

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.date='yesterday'

and that did not work just listed everyone

RE: [SQL] Query Help

[Francis Solomon]

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 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.date='yesterday'
>
> and that did not work just listed everyone

Re: [SQL] Query Help

[Yury Don]

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,
 Yurymailto:[EMAIL PROTECTED]