Page 1 of 1

mysql statement

Posted: Sun Nov 12, 2006 11:12 pm
by aussie_clint
cant get this to work, can someone let me know where im going wrong, thanks

Code: Select all

SELECT newprice list.PartNumber
FROM newprice list
LEFT JOIN `price list` ON newprice list.PartNumber = price list.PartNumber
WHERE price list.PartNumber IS NULL

Posted: Mon Nov 13, 2006 12:50 am
by Christopher
If you are going to have table names with spaces in them then you will need to put backticks around the name (e.g. `price list`). I would recommend renaming the tables and changing the spaces to underscores.