Wie kann ich tabellenübergreifende Daten einlesen?

[DeddyH]

Und so?

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 
from Antragsteller1 A1 join Akten on Akten.Aktennr=A1.zu_Akte 
where Akten.Aktennr = 1