Extreme Veteran
Beiträge: 566
| 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 |