compareing two table
Posted: Sat Nov 11, 2006 4:11 pm
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
thanks
Code: Select all
SELECT n.PartNumber FROM `newprice list`
WHERE n.PartNumber not in (SELECT n.PartNumber FROM `price list`);