On 2 Aug 2002, at 11:43, Luc Foisy wrote: > FROM EVENTATTENDANCE > LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID > LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID > LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID > LEFT JOIN ORGANIZATION ON CONTACT.ID_ORGANIZATION = ORGANIZATION.ID > LEFT JOIN TYPE RELATIONSHIP ON CONTACT.ID_TYPE_RELATIONSHIP = TYPE.ID > LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = TYPE.ID > WHERE EVENTATTENDANCE.ID_EVENT = -1 ORDER BY CONTACT.FirstName SQL > Error in populateDataSet ============================== Please Restart > The Application ============================== SQLException: General > error: Unknown table 'TYPE' in on clause
You've assigned the aliases RELATIONSHIP and SALUTATION to the TYPE table, so you need to use those in place of TYPE for your join criteria. Change TYPE.ID to RELATIONSHIP.ID and SALUTATION.ID. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
