Questions

[mayu03]

In first query I am getting result back.Second query should get the same data back (just different syntax). I can't see where my error is, but my second query is not returning any result back.Pleae help
1.select a.lastname
from Table1 a Left join table2 b
On a.lastname=b.last
2. select a.lastname
from Table1 a
where NOT EXISTS (select last from table2 )

 

[JohnDTampaBay]

If you want data from Table1 that doesn't appear in Table2, then both queries need a little work.

Query 1:
select a.lastname
from Table1 a Left join table2 b
On a.lastname=b.last
where b.last is null

Query 2:
select a.lastname
from Table1 a
where NOT EXISTS (select last
from table2 b
where b.last = a.lastname)


--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[BSman]

Or, if your original query1 is giving you the results you want, change Query 2 to the following:

select a.lastname
from Table1 a
where a.lastname IN (select last from table2
where a.lastname = b.last)