I get the error ERROR 1066 (42000): Not unique table/alias:
I cant figure out whats wrong with it.
SELECT Project_Assigned.ProjectID, Project_Title, Account.Account_ID, Username, Access_Type
FROM Project_Assigned
JOIN Account
ON Project_Assigned.AccountID = Account.Account_ID
JOIN Project
ON Project_Assigned.ProjectID = Project.Project_ID
where Access_Type = 'Client';
This question is related to
mysql
mysql-error-1066
select persons.personsid,name,info.id,address
-> from persons
-> inner join persons on info.infoid = info.info.id;
Source: Stackoverflow.com