db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kent Spaulding <k...@iotabits.com>
Subject Derby Syntax for (+)?
Date Wed, 18 Feb 2009 22:18:45 GMT
Hi again,

I hope this is a simple question: one troubling query:

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?

View raw message