Re: [sqlite] Is this a valid syntax

[Paul Smith]

At 16:45 17/04/2007, Stef Mientki wrote:
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')

SELECT PO.* FROM Koppel
 LEFT JOIN PO
   WHERE (Koppel.K_App == PO.App)
         AND (Koppel.K_naam == 'MVE')
         AND (PO.ALL_answered != '0')

I don't know if this is the problem, but, for some reason you're 
mixing C/C++ syntax in with SQL there.

You don't use '==', you should just use '='
You don't use '!=', you should use '<>'

So, try
SELECT PO.* FROM Koppel
 LEFT JOIN PO
   WHERE (Koppel.K_App = PO.App)
         AND (Koppel.K_naam = 'MVE')
         AND (PO.ALL_answered <> '0')


Paul                            VPOP3 - Internet Email Server/Gateway
[EMAIL PROTECTED]                      http://www.pscs.co.uk/



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------