Código:
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
#1066 - Not unique table/alias: 'comp-department'
Alguien sabe que pasa?