Hi Simon. Your test works fine. I have returned all lines... Which could be the problem?
-----Messaggio originale----- From: Simon Slavin Sent: Monday, June 20, 2011 10:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with System.Data.SQLite and join II On 20 Jun 2011, at 9:49pm, Alessandro Caliaro wrote: > SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA, > COM_STRADARIO.NOME_VIA FROM COM_STRADARIO inner join INT_CONDOMINI on > COM_STRADARIO.ID_STRADARIO = INT_CONDOMINI.ID_STRADARIO ORDER BY NOME_VIA > > It works fine if I run with SQLiteManager for Firefox, but with > System.Data.Sqlite no rows are returned. > > Can you help me? > > I use 1.0.65.0 with 2.0.50727 runtime and SQLite.Interop.065.dll Try the same SELECT with the command-line shell under Windows: http://www.sqlite.org/sqlite.html download it from here: http://www.sqlite.org/download.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users