LEFT JOINS same data twice?

[Chris Knipe]

Hi,

Is it possible to left join the same data twice?

TBL ONE:
LocationID
Location, varchar(100)

TBL TWO:
DepartureID,
ArrivalID,
Time

SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS 
Destination LEFT JOIN DepartureLocation ON tlb2.DepartureID=tlb1.LocationID 
LEFT JOIN DepartureLocation ON tbl2.ArrivalID=tbl1.LocationID ORDER BY 
tbl2.Time etc etc etc


I get

ERROR 1066 (42000): Not unique table/alias: 'tbl1'


Thanks.



--
Chris.

I love deadlines. I especially love the whooshing sound they make as they 
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'