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' 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]