INNER JOIN在oracle中不能用 oracle中只能通过表关联或者表联接(+)来实现 创建视图用 create view viewname as select * from tablename;
SELECT a.OperAccount, a.OperID, c.AppDepID, c.IsAutoNum, a.OperName, b.DllNameID from OperAccount a,OperDllNames b,dep_table c,Medi_ApplyDepdep_table d where a.OperID=b.OperID and b.Depid=c.Depid and c.depid=d.depid
oracle中只能通过表关联或者表联接(+)来实现
创建视图用
create view viewname as select * from tablename;
c.AppDepID, c.IsAutoNum,
a.OperName, b.DllNameID
from OperAccount a,OperDllNames b,dep_table c,Medi_ApplyDepdep_table d where a.OperID=b.OperID and b.Depid=c.Depid and c.depid=d.depid