[SQL] how to do 'deep queries'?

[jeff sacksteder]

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