If i write a sql:
You're much better off using the ANSI syntax
SELECT * FROM a LEFT OUTER JOIN b ON( a.id = b.id and b.val = 'test' )
You can do the same thing using Oracle's syntax as well but it gets a bit hinkey
SELECT * FROM a, b WHERE a.id = b.id(+) AND b.val(+) = 'test'
Note that in both cases, I'm ignoring the
c table since you don't specify a join condition. And I'm assuming that you don't really want to join A to B and then generate a Cartesian product with C.