MySQL Forums
Forum List  »  German

Re: Wie folgende Abfrage realisieren
Posted by: Thomas Power
Date: January 26, 2010 12:01PM

Ok, hab die Lösung selber gefunden. Für alle, die mal auf das gleiche Problem stoßen und nicht auf Anhieb wissen, wie Sie es lösen sollen:

SELECT t2.*, T1.name AS n1, T1.name AS n2, T1.name AS n3
FROM t2
LEFT JOIN t1 AS T1 ON t2.feld1 = T1.id
LEFT JOIN t1 AS T2 ON t2.feld2 = T2.id
LEFT JOIN t1 AS T3 ON t2.feld3 = T3.id

Options: ReplyQuote


Subject
Views
Written By
Posted
3120
January 26, 2010 11:19AM
Re: Wie folgende Abfrage realisieren
1629
January 26, 2010 12:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.