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 (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 > > ;
without seeing the real sql it's hard to optimize it
