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] -----------------------------------------------------------------------------