Hi mate,

I believe Oracle does not support the "inner join" syntax which is fair enough as it's really just a simple join.


An sql server query :
select * from a inner join b on a.col1=b.col2;

would be translated to Oracle as

select * from a , b where a.col1=b.col2;

FYI your original query would work on DB2.

Hope this helps

Nick