select distinct o.d, o.u, o.e
from my_table o, my_table_2 t
where o.u = t.u(+)
and t.u is null
and o.u not like 'P%';
This fails with a syntax error - on the (+) on line 3 of the SQL -
what's the corresponding Derby syntax?
Looks like you may be trying to write an outer join. You can
find the Derby syntax for outer joins documented here:
http://db.apache.org/derby/docs/10.4/ref/rrefsqlj18922.html
I think you'll want something like
select distinct o.d, o.u, o.e
from my_table o left outer join my_table_2 t on o.u = t.u
where t.u is null and o.u not like 'P%';
thanks,
bryan
