Wie kann ich tabellenübergreifende Daten einlesen?

[DeddyH]

SQL-Code:

Select Akten.*,A1.zu_Akte as A1_zuAkte,
       A1.Titel as A1_Titel, A1.Vorname as A1_Vorname,
       A1.Nachname as A1_Nachname, A1.Geburtsdatum as A1_Geburtsdatum,
       A1.Strasse as A1_Strasse, A1.Hausnr as A1_Hausnr,
       A1.PLZ as A1_PLZ, A1.Ort as A1_Ort,
       A1.Familienstand as A1_Familienstand, A1.Brutto as A1_Brutto,
       A2.zu_Akte as A2_zuAkte,
       A2.Titel as A2_Titel, A2.Vorname as A2_Vorname,
       A2.Nachname as A2_Nachname, A2.Geburtsdatum as A2_Geburtsdatum,
       A2.Strasse as A2_Strasse, A2.Hausnr as A2_Hausnr,
       A2.PLZ as A2_PLZ, A2.Ort as A2_Ort,
       A2.Familienstand as A2_Familienstand, A2.Brutto as A2_Brutto
from Antragsteller1 A1 
join Akten on Akten.Aktennr=A1.zu_Akte
left join Antragsteller2 A2 on Akten.Aktennr=A2.zu_Akte
where Akten.Aktennr = 1

Getippt und nicht getestet.