mehrere Left-Joins in Jet SQL
PeterDoering
Gesendet: 24.07.17 18:55
Betreff: RE: mehrere Left-Joins in Jet SQL



Extreme Veteran

Beiträge: 563
5002525
SvenG - 24.07.17 11:32
SELECT b.So_SOP AS Au_WertAlt, c.So_SOP AS Au_WertNeu, a.Au_Datum, a.Au_Grund, a.Us_UserID
FROM (tblAudit a LEFT JOIN tblExtractionSOP b ON b.So_ID=CINT(a.Au_WertAlt))
LEFT JOIN tblExtractionSOP c ON c.So_ID=CINT(a.Au_WertNeu)
WHERE a.Au_FeldNr=2004 AND Au_TabellePK=14023
ORDER BY a.Au_Datum;

Probier mal so:

FROM (tblAudit a LEFT JOIN tblExtractionSOP b ON a.Au_WertAlt = CStr(b.So_ID))
LEFT JOIN tblExtractionSOP c ON a.Au_WertNeu=CStr(c.So_ID)

(ungetestet)

-----
Gruss - Peter
Top of the page Bottom of the page