This seems ok in access but is it valid in oracle
from ord_si inner join ord_mm on ord_si.wss_tid = ord_mm.fsi_tid;
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
Click Here to Expand Forum to Full Width