>I understand that but why the same query, with the same data, return two >different result using different SQLite-based Win32 applications ?
SQL is essentially based on set theory. Sets don't have intrinsic ordering and may be enumerated in whatever order. What you think are distinct results are not distinct from the SQL point of view. >In any case how I can take the result I need ? I not have other column >right for made one ORDER BY and I need to respect the sequence or CODE >table like > >The table CODE. >CODE;VALUE; >61311;18462F; >61311;18461F; > >The table JOB >CODE;NUM; >61311;1; >61311;1; > >Table ELAB with desired result. >CODE;VALUE; >61311;18462F; >61311;18461F; >61311;18462F; >61311;18461F; Add a sequence number (or simply an explicit INTEGER primary key) to your tables and ORDER BY the result on them. -- <mailto:j...@q-e-d.org>j...@antichoc.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users