> 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. >
Ahh, so LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = SALUTATION.ID ?? --------------------------------------------------------------------- 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