Not unique table alias

Question

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

User · Answer

select persons personsid name info id address     - gt  from persons     - gt  inner join persons on info infoid   info info id

User · Answer

Your query contains columns which could be present with the same name in more than one table you are referencing  hence the not unique error  It s best if you make the references explicit and or use table aliases when joining  Try     SELECT pa ProjectID  p Project Title  a Account ID  a Username  a Access Type  c First Name  c Last Name       FROM Project Assigned pa INNER JOIN Account a         ON pa AccountID   a Account ID INNER JOIN Project p         ON pa ProjectID   p Project ID INNER JOIN Clients c         ON a Account ID   c Account ID      WHERE a Access Type    Client

[mysql] Not unique table/alias

Examples related to mysql

Examples related to mysql-error-1066