List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:April 13 2005 3:01am
Subject:LEFT JOINS same data twice?
View as plain text  
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' 

Thread
LEFT JOINS same data twice?Chris Knipe13 Apr
  • Re: LEFT JOINS same data twice?Peter Brawley13 Apr
  • Re: LEFT JOINS same data twice?Rhino13 Apr
  • Re: LEFT JOINS same data twice?Roger Baklund13 Apr
  • Re: LEFT JOINS same data twice?Chris Knipe15 Apr
    • Re: LEFT JOINS same data twice?SGreen15 Apr
      • Re: LEFT JOINS same data twice?Peter Brawley15 Apr
      • Re: LEFT JOINS same data twice?Chris Knipe15 Apr
        • Re: LEFT JOINS same data twice?SGreen15 Apr
          • Re: LEFT JOINS same data twice?SGreen15 Apr