Re: how to do 'deep queries'?

> Is there supported syntax to do 'deep' queries? That is where
> A relates to B relates to C, returning fields from each table?
>
> This doesn't seem to work. Is there a google-able term for
> this sort of query?
>
> select
>    foo.aaa,
>    bar.bbb,
>    baz.ccc
>
> from
>    foo,bar,baz
>
> where
>    foo.bar_id = bar.id
> and
>    bar.baz_id = baz.id

This works for me..

SELECT table1.state, table2.coursename, table3.firstname FROM backend.enrolments table1, backend.courses table2,
backend.users
table3WHERE table1.user = table3.employeeno  AND table1.course = table2.courseid;

What errors are you getting?

Best regards,

Ben Stewart

--
Robert Bosch (Australia) Pty. Ltd.
Engineering Quality Services, Student Software Engineer (RBAU/EQS4)
Locked Bag 66 - Clayton South, VIC 3169 - AUSTRALIA
Tel: +61 3 9541-7002 Fax: +61 3 9541-7700
mailto:ben.stewart@au.bosch.com
http://www.bosch.com.au/