hi all, I am porting a program from mysql to sqlite. The following statement doesn't work correctly with sqlite though it does with mysql. SELECT COUNT(*) AS nb FROM ttd_photos LEFT JOIN ttd_trees ON ttd_photos.kind=1 AND ttd_photos.refId=ttd_trees.treeId LEFT JOIN ttd_pots ON ttd_photos.kind=2 AND ttd_photos.refId=ttd_pots.potId
In my test case, it reports 0 where it should report 2. This is the LEFT JOIN part which has a problem ;) Any idea ? Thanks, Alain
