Re: [sqlite] Strange result using JOIN

Many thanks to all those who have given me great tips. *Sintoni Stefano* ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange result using JOIN

2011/7/22 Sintoni Stefano (GMAIL) : > 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

Re: [sqlite] Strange result using JOIN

On Fri, Jul 22, 2011 at 03:37:34PM +0200, Sintoni Stefano (GMAIL) scratched on the wall: > More thanks, > I understand that but why the same query, with the same data, return two > different result using different SQLite-based Win32 applications ? My best guess is that they're using different

Re: [sqlite] Strange result using JOIN

e From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sintoni Stefano (GMAIL) [stefano.sintoni.cnigr...@gmail.com] Sent: Friday, July 22, 2011 8:54 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Strange result using JOIN I don't have ot

Re: [sqlite] Strange result using JOIN

I don't have other column good for use the SELECT. Now I don't have good columns to use the SELECT, now I'm afraid my only solution is to create a new column with a value of the order generated by my application. Stefano On 07/22/2011 03:45 PM, Simon Slavin wrote: > On 22 Jul 2011, at 2:37pm,

Re: [sqlite] Strange result using JOIN

>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

Re: [sqlite] Strange result using JOIN

On 22 Jul 2011, at 2:37pm, Sintoni Stefano (GMAIL) wrote: > 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; SQL has no

Re: [sqlite] Strange result using JOIN

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

Re: [sqlite] Strange result using JOIN

On Fri, Jul 22, 2011 at 09:23:36AM +0200, Sintoni Stefano (GMAIL) scratched on the wall: > Hi, > I get a strange result using JOIN on one very simple application using > SQLite. > The table ELAB are populated with the follow SQL query: > INSERT INTO ELAB SELECT CODE.* FROM JOB JOIN CODE ON

[sqlite] Strange result using JOIN

Hi, I get a strange result using JOIN on one very simple application using SQLite. I have made one Win32 custom application (made with MS Visual Studio 6) using sqlite3.dll rel. 3.7.2. On my situation I have three table like follow. Table CODE made with: CREATE TABLE CODE (CODE TEXT DEFAULT