mysql statement

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:

mysql statement

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post 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.
(#10850)
Post Reply