I don't understand this behaviour,
is this too complex ?
or am I doing something wrong ?
I use the following syntax, and I get 7 records back,
(which is not correct in my opinion)
SELECT PO.* FROM Koppel
LEFT JOIN PO
WHERE (Koppel.K_App == PO.App)
AND (Koppel.K_naam == 'MVE')
AND (PO.ALL_answered == '0')
If I leave the last line out,
I get 16 records (which might be ok, I can't check it)
SELECT PO.* FROM Koppel
LEFT JOIN PO
WHERE (Koppel.K_App == PO.App)
AND (Koppel.K_naam == 'MVE')
Now if I only invert the last line,
and suposing the above results where ok (which isn't),
I should get 16-7= 9 records back.
SELECT PO.* FROM Koppel
LEFT JOIN PO
WHERE (Koppel.K_App == PO.App)
AND (Koppel.K_naam == 'MVE')
AND (PO.ALL_answered != '0')
But this just returns 0 records ????
I tried all kinds of combinations, nested select statements etc,
but most of them (may be all, can't remember anymore),
returns 16-0-7 records.
Sorry, I must be doing something terrible wrong, but I don't see the clue.
thanks,
Stef Mientki
Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of
Commerce - trade register 41055629
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
