[RESOLVED] Need help with a querry

[shakti5385]

SELECT Table2.BookingID, T1.Name, T2.Name, Arraival, Derparture
FROM (Table2 LEFT JOIN Table1 AS T1 ON Table2.GuestID1 = T1.GuestID) LEFT JOIN Table1 AS T2 ON Table2.GuestID2 = T2.GuestID

Use Left Join

[szlamany]

This should work (use ALIAS syntax)

Select TA.BookingId
		,TA.GuestID1
		,T1.GuestName as GuestName1
		,TA.GuestID2
		,T2.GuestName as GuestName2
		,TA.Arrival
		,TA.Departure
	From Table2 TA
	Left Join Table1 T1 on T1.GuestId=TA.GuestID1
	Left Join Table1 T2 on T2.GuestId=TA.GuestID2

This would work in MS SQL - you can join the same table as many times as you want as long as you give them a unique alias name.

[Bongo]

This should work (use ALIAS syntax)

Select TA.BookingId
		,TA.GuestID1
		,T1.GuestName as GuestName1
		,TA.GuestID2
		,T2.GuestName as GuestName2
		,TA.Arrival
		,TA.Departure
	From Table2 TA
	Left Join Table1 T1 on T1.GuestId=TA.GuestID1
	Left Join Table1 T2 on T2.GuestId=TA.GuestID2

This would work in MS SQL - you can join the same table as many times as you want as long as you give them a unique alias name.

@shakti5385 - thx

@szlamany
thx as well but I still get an error which says roughly translatet into english

Syntaxerror (missing operator) on query 'T1.GuestID=TA.GuestID1 ON (Left Join Table1 T2 on T2.GuestId=TA.GuestID2)'

What else I am doing wrong?

[Bongo]

Its Working

Many thanks to you guys and to all a merry xmas and a good 2007