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
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