> 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 CONTAC
> Luc Foisy wrote:
>
> >Since the below select query blew up on me, then I must be
> doing something wrong, perhaps it is because I am using the
> wrong type of join, dunno
> >I would like to join the same table twice, with different
> criteria as below
> >
> >Anyone got a solution to this?
>
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_ORGANIZAT
Since the below select query blew up on me, then I must be doing something wrong,
perhaps it is because I am using the wrong type of join, dunno
I would like to join the same table twice, with different criteria as below
Anyone got a solution to this?
SELECT EVENTATTENDANCE.ID,
CONCAT
