Christian Smith <[EMAIL PROTECTED]> wrote: > > select .... > > FROM instances as i > > inner join instance_fields as count using(instanceid) > > inner join instance_fields as first using (instanceid) > > inner join instance_fields as last using (instanceid) > > inner join instance_fields as severity using (instanceid) > > inner join instance_fields as summary using (instanceid) > > inner join instance_fields as node using (instanceid) > > inner join instance_fields as source using (instanceid)
I believe that USING is broken when there are more than two tables in the join. Try an ON clause instead and see if that doesn't work better. -- D. Richard Hipp <[EMAIL PROTECTED]>