I have a query which successfully runs on PHP5, which I beleive has sqlite 2.8.11 
embedded, but run it in sqliteplus (windows GUI using 2.8.12) it does not return any 
results. I have check with eZtools the provider of Sqliteplus and they can not find 
fault with their program.
Is there any differences in these to versions which would stop the following query 
returning results.

sql--------------------------------------------------------------------------------------
SELECT C.extn_no AS extn_no, dest, dest_name, call_time, duration, cost, firstname, 
surname
FROM call_data as C INNER JOIN users as U on C.extn_no = U.extn_no WHERE '1' = '1'
AND call_time >= '2004-12-12 00:00:00' AND call_time <= '2004-12-12 23:59:59'
AND direction = 'Out' AND U.user_id IN (SELECT user_id FROM grp_user WHERE group_id = 
'1') LIMIT 0,1
------------------------------------------------------------------------------------------

Reply via email to