SQL - MINUS

[SAMS]

Hi Guys,

Another question abt SQL, I got two tables and I wanted to find out who is in Q table and not in W table? So I used these code:

Select Name From q Minus Select Vendor From w

Error: Syntax error in From?

Please do correct me if my code is wrong.

Thks.

[Serge]

Try this:


Select Name From Q Left Join W On Q.SomeID = W.SomeID Where W.Name Is Null


SomeID is a field that is common in both tables.

Regards,

------------------

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com

[Jamppa]

or you can use alternatively code as follows:

select Q.Name from Q where Q.Name Not in (select W.Name from W)


Jan

[This message has been edited by Jamppa (edited 09-04-1999).]

[SAMS]

Thanks for all your help. Thks all of you