maybe an easy join

[michelleqw]

Dear sql user,

We do have to tables:

TblX tBLy
Fld_x fLD_Y
A A
B
C

We are trying to get a join with the next result:

Fld
B
C

Can someone give us a solution?

Nice regards,

Michelle.

 

[PHV]

SELECT Fld_x
FROM TblX LEFT JOIN tBLy ON Fld_x = fLD_Y
WHERE fLD_Y IS NULL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[r937]

select Fld_x as Fld from TblX
except
select fLD_Y from tBLy

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[PruSQLer]

Okay, which one is faster, the EXCEPT or the LEFT OUTER JOIN where field is NULL? Or does the optimizer just end up running a Leftie anyway?

 

[r937]

depends on the optimizer

some of them don't even recognize EXCEPT

i just thought i'd throw that solution in because of, you know, which forum this is



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[michelleqw]

Thanks all for the information.

Michelle.