2011/7/22 Sintoni Stefano (GMAIL) <stefano.sintoni.cnigr...@gmail.com>: > More thanks, > I understand that but why the same query, with the same data, return two > different result using different SQLite-based Win32 applications ? > > 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 > Any idea ? > Stefano
INSERT INTO ELAB SELECT CODE.* FROM JOB JOIN CODE ON CODE.CODE=JOB.CODE ORDER BY JOB.rowid,CODE.rowid; -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users