--- 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 = table3.name_id) > INNER JOIN table4 ON (table4.id = table3.id) > INNER JOIN table5 ON (table4.table5_id = table5.id) > ) AS files GROUP BY tables.id > ; > > I know the query doesn't look useful like this, but with > WHERE and UNION ALL > it will be (for me). The problem is I can't get passed > here. SQLite gives me > a "SQL error: no such column: tables.id" even if I remove > the GROUP by, I > still revieve the error. > It seems that SQLite cannot reference aliased columns > properly from the > derived table. Am I right or is there a problem with my > SQL? This works fine > in MySQL. I can even remove the alias and reference the > column by its > original table name. However thats not possible in SQLite > either. > Any ideas appreciated once again, thank you. > - Dave > FWIW, maybe I'm missing something, but I don't see where you've aliased anything as "tables". In the example, it looks like you've aliased the subquery as "files". -Clark
