Hi,
I am trying to run the following query, which I thought should work, based on my understanding (newly acquired).
SELECT places.center contacts.name FROM places, center
LEFT JOIN places ON places.center = contact.center;
When I run it I get error 1066 not unique table/alias.
TIA
Ramon
I am trying to run the following query, which I thought should work, based on my understanding (newly acquired).
SELECT places.center contacts.name FROM places, center
LEFT JOIN places ON places.center = contact.center;
When I run it I get error 1066 not unique table/alias.
TIA
Ramon