Wednesday, November 01, 2006

SQL Question (Alex's responce)

Select price from table two except select price from table one.

If the except command does not work, try this:

Select price from table two where not exists (Select * from table one
where two.id=one.id)

It should be something like that.

http://msdn.microsoft.com/office/program/access/default.aspx

0 Comments:

Post a Comment

<< Home