View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 08:10 AM
blueghost73@yahoo.com
 
Posts: n/a
Default Re: Query table based on multiple keys



--CELKO-- wrote:
> SELECT a1, a2, a3, a4
> FROM A
> WHERE NOT EXISTS
> (SELECT *
> FROM B
> WHERE A.a1 = B.b1
> AND A.a2 = B.b2
> AND A.a3 = B.b3
> AND A.a4*= B.b4 );



Yeah, that works better than my version. I just tested a little more
and realized that mine doesn't actually do what I expected, but I can't
figure out why not.

--Richard

Reply With Quote