Re: [sqlite] Re: A valid SQL fails with SQLite

2007-11-23 Thread Kees Nuyt
On Fri, 23 Nov 2007 18:47:40 +0100, <[EMAIL PROTECTED]> wrote: >Btw, what would be the best GUI to use? I am happy with SQLite3Explorer. http://www.sqlite.org/cvstrac/wiki?p=ManagementTools http://www.singular.gr/sqlite/ HTH -- ( Kees Nuyt ) c[_] -

Re: [sqlite] Re: A valid SQL fails with SQLite

2007-11-23 Thread P Kishor
essage - > From: "Igor Tandetnik" <[EMAIL PROTECTED]> > To: "SQLite" > Sent: Friday, November 23, 2007 6:22 PM > Subject: [sqlite] Re: A valid SQL fails with SQLite > > > > [EMAIL PROTECTED] wrote: > >> As you can see, the same color (the la

Re: [sqlite] Re: A valid SQL fails with SQLite

2007-11-23 Thread runehjelm
quot;SQLite" Sent: Friday, November 23, 2007 6:22 PM Subject: [sqlite] Re: A valid SQL fails with SQLite [EMAIL PROTECTED] wrote: As you can see, the same color (the last one, emissive) will be the result for ALL colors. It seems as if your SQL-interpreter cannot handle multiple definitions of

[sqlite] Re: A valid SQL fails with SQLite

2007-11-23 Thread Igor Tandetnik
[EMAIL PROTECTED] wrote: As you can see, the same color (the last one, emissive) will be the result for ALL colors. It seems as if your SQL-interpreter cannot handle multiple definitions of the same table (aliased with AS) in the FROM-clause? Everything works correctly for me with sqlite3 com