Re: [sqlite] New Query Question

2005-07-27 Thread David Fowler
From: John LeSueur <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] New Query Question Date: Tue, 26 Jul 2005 19:51:54 -0600 MIME-Version: 1.0 Received: from sqlite.org ([67.18.92.124]) by mc11-f29.hotmail.com with Microsoft S

Re: [sqlite] New Query Question

2005-07-26 Thread John LeSueur
David Fowler wrote: Really sorry guys, AS files, should indeed be AS tables, thats what does not work. Sorry again for the copy/pasting/editing error. When I remember to name everything correctly, I still can't select anything by table.column sytax that is in the derived table, wether the deri

Re: [sqlite] New Query Question

2005-07-26 Thread David Fowler
Really sorry guys, AS files, should indeed be AS tables, thats what does not work. Sorry again for the copy/pasting/editing error. When I remember to name everything correctly, I still can't select anything by table.column sytax that is in the derived table, wether the derived table is aliased o

Re: [sqlite] New Query Question

2005-07-26 Thread David Fowler
Really sorry guys, AS files, should indeed be AS tables, thats what does not work. Sorry again for the copy/pasting/editing error. When I remember to name everything correctly, I still can't select anything by table.column sytax that is in the derived table, wether the derived table is aliased o

Re: [sqlite] New Query Question

2005-07-26 Thread Petr Fejfar
David Fowler wrote: > The problem is I can't get passed > here. SQLite gives me a "SQL error: no such > column: tables.id" What is the alias "files" for? Should not it be "table"? pf

Re: [sqlite] New Query Question

2005-07-26 Thread Jay Sprenkle
On 7/26/05, Clark Christensen <[EMAIL PROTECTED]> wrote: > > > --- David Fowler <[EMAIL PROTECTED]> wrote: > > > Hello again to everyone. > > I'm having trouble with the following query: > > SELECT tables.id FROM ( > > SELECT table4.location, table4.id > > FROM table1 > > INNER JOIN table2 ON (t

Re: [sqlite] New Query Question

2005-07-26 Thread Clark Christensen
--- David Fowler <[EMAIL PROTECTED]> wrote: > Hello again to everyone. > I'm having trouble with the following query: > SELECT tables.id FROM ( > SELECT table4.location, table4.id > FROM table1 > INNER JOIN table2 ON (table1.class_id = table2.class_id) > INNER JOIN table3 ON (table2.name_id = ta

[sqlite] New Query Question

2005-07-26 Thread David Fowler
Hello again to everyone. I'm having trouble with the following query: SELECT tables.id FROM ( SELECT table4.location, table4.id FROM table1 INNER JOIN table2 ON (table1.class_id = table2.class_id) INNER JOIN table3 ON (table2.name_id = table3.name_id) INNER JOIN table4 ON (table4.id = table3.id) I