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 <http://bar.id>
and
bar.baz_id = baz.id <http://baz.id>