Hallo
PASST,
versuch es doch mal so...
SQL-Code:
SELECT t1.FeldA, t2.FeldB
FROM tab1 t1
LEFT JOIN tab2 t2
ON t1.Feld1 = t2.Feld1
AND t1.Feld2 = t2.Feld2
AND COALESCE(t2.Feld5, 100) = 100
eventuell kennt dbase COALESCE nicht...
SQL-Code:
SELECT t1.FeldA, t2.FeldB
FROM tab1 t1
LEFT JOIN tab2 t2
ON t1.Feld1 = t2.Feld1
AND t1.Feld2 = t2.Feld2
AND ( t2.Feld5 IS NULL
OR t2.Feld5 = 100)
Gruss
Thorsten