Page 1 of 1

compareing two table

Posted: Sat Nov 11, 2006 4:11 pm
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`);

Posted: Sat Nov 11, 2006 4:12 pm
by feyd
Have a look through Useful Posts.