On 04/21/10 12:45 PM, Jayaram Subramanian wrote:
> Hi Knut,
> For buddy testing of Derby 4370 (using clause), I was going through
> the jointest junit file to find the validation test cases and was just
> wondering whether using both on and using in a singled sql statement
> is allowed
>
> For example
> JDBC.assertUnorderedResultSet(
> s.executeQuery("select * from t1 left join t2 " +
> "right join t3 on (d) using (b)"),
>
Hi Jayaram,
It should be fine to mix ON and USING withing a single statement. The
above statement should fail, though, because the ON clause ("on (d)") is
invalid. The ON clause needs a boolean expression, like T2.A = T3.B.
--
Knut Anders
