Código:
#1066 - Not unique table/alias: 'comp-department' SELECT `comp-department`. * , GROUP_CONCAT( CONCAT( `license`.LicenseType, ' -> ', `right`.RightType ) ORDER BY `license`.LicenseType DESC SEPARATOR ', ' ) AS Rights FROM `comp-department` LEFT JOIN `comp-dep-access` ON `comp-department`.DepId=`comp-dep-access`.DepId LEFT JOIN `comp-department` ON `department-right`.DepId=`comp-department`.DepId LEFT JOIN `department-right` ON `department-right`.RightId=`department-right`.RightId LEFT JOIN `license` ON `right`.LicenseId=`license`.LicenseId WHERE `comp-dep-access`.CompId =10 GROUP BY `comp-department`.DepName
Alguien sabe que pasa?