compareing two table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
aussie_clint
Forum Commoner
Posts: 41
Joined: Mon Jul 31, 2006 9:14 am
Location: Brisbane, Australia
Contact:

compareing two table

Post by aussie_clint »

Hi, tring to compare two table to find out if there are any new products since the last price list, could some one let me know where im going rong with this one

thanks

Code: Select all

SELECT n.PartNumber FROM `newprice list`
WHERE n.PartNumber not in (SELECT n.PartNumber FROM `price list`);
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Have a look through Useful Posts.
Post Reply