Re: SQL Syntax headache

[Jay Pipes]

Make sure you are using a version of MySQL that supports subqueries (4.1 and up).

or use the standard, efficient INNER JOIN:

SELECT c1.ID, c1.DateEntered, c1.name, c2.Company as myCompany
FROM contacts c1
INNER JOIN contacts c2
ON c1.DiveShopRef = c2.ID
ORDER by c1.ID ASC;

For best performance, make sure you have an index on contacts.DiveShopRef

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com