from A
 left outer join B on (a.foo = b.foo)
 left outer join C on (b.bar = c.bar)