日期:2014-05-16 浏览次数:20723 次
select d.project_name from a,b,c,d where a.id=b.user_id(+) and b.resource_id=c.id(+) and c.function_id=d.id(+)
------解决方案--------------------
楼上的少了个约束条件,而且这种查询不需要左连接吧?
SELECT D.PROJECT_NAME FROM A,B,C,D WHERE A.ID = B.USER_ID AND B.RESOURCE_ID = C.ID AND C.FUNCTION_ID = D.ID AND A.NAME = '已知字段值'