How to link three tables with joins on one table?

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)

RE: How to 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) inn

RE: How to link three tables with joins on one table?

Hi. On Tue, Oct 02, 2001 at 07:25:38AM +0200, [EMAIL PROTECTED] wrote: [...] > first thanks for your answer. > Your example does not work because the IdentNrS field is not in the table > Bestellungen_Status. Sorry, but there is no such table "Bestellungen_Status"? You mean Bestellungen_Status_Te