[sqlite] Is this a valid syntax

[Stef Mientki]

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