Hallo, how can i link three tables with joins on one table?
Select b.IdentNrA,b.Menge,b.Preis,b.ArtPosition,c.Artikel_Status,d.beschTitel,e.Str asse,e.PLZ,e.Stadt,e.Land From Bestellungen_Status_Text f right join (BestellungenAdr e inner join Bestellungen a using(IdentNrS)) using (BestellStatus) inner join BestellungenP b using (IdentNrS) inner join artikel c using (IdentNrA) inner join ArtikelText d using (IdentNrA) Where b.IdentNrS = 22 and d.Sprache = 'DE' Order By b.ArtPosition does not work. Thank you very much Armin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php