Forum: Datenbanken
Delphi
by Metallicwar,
12. Dez 2013
SELECT
mas.ID, 'Mustermann, Max' as Name,
bd.Datum,
be.Sollzeit,
b.Me1, b.Me2
FROM MA_Stammdaten mas
LEFT OUTER JOIN Buchungsdatei bd ON mas.ID = bd.ID_MA_Stammdaten
LEFT OUTER JOIN Buchungen b ON (bd.ID_MA_Stammdaten = b.ID_MA_Stammdaten AND bd.Datum = b.Datum)
LEFT OUTER JOIN B_Ergebnisse be ON bd.ID = be.ID_Buchungsdatei...
Forum: Datenbanken
Delphi
by Metallicwar,
12. Dez 2013
Moin zusammen!
SELECT
mas.ID, 'Mustermann, Max' as Name,
bd.Datum,
be.Sollzeit,
b.Me1, b.Me2
FROM MA_Stammdaten mas
LEFT OUTER JOIN Buchungsdatei bd ON mas.ID = bd.ID_MA_Stammdaten
LEFT OUTER JOIN Buchungen b ON (bd.ID_MA_Stammdaten = b.ID_MA_Stammdaten AND bd.Datum = b.Datum)
LEFT OUTER JOIN B_Ergebnisse be ON bd.ID = be.ID_Buchungsdatei