如果要保存b.Functionid的数据,并且关联c.Functionid可以试一下: SELECT a.*,c.FunctionName FROM a,b,c where b.Functionid = a.Functionid(+) AND b.mobileid = a.mobileid(+) AND b.Functionid=c.Functionid(+)
SELECT a.*,c.FunctionName from b, a, c where b.Functionid = a.Functionid(+) AND b.mobileid = a.mobileid(+) AND b.Functionid=c.Functionid把b,a顺序交换一下
以上问题我已找到原因!问个下面的问题:表a: id oid notes表b: objectid obname type视图: create or replace view v_b as select * from b where type=4用了视图的左联: select a.id, from a,v_b where mff.ID=v_b.objectid(+)如何不用视,就一条SQL语句搞定????
select a.id,from a,(select * from b where type=4) b where a.ID=b.objectid(+)
select a.id from a,b where a.ID=b.objectid(+) and b.type=4
SELECT a.*,c.FunctionName
FROM a,b,c
where b.Functionid = a.Functionid(+) AND
b.mobileid = a.mobileid(+) AND
b.Functionid=c.Functionid(+)
from b, a, c
where b.Functionid = a.Functionid(+) AND
b.mobileid = a.mobileid(+) AND
b.Functionid=c.Functionid把b,a顺序交换一下
id oid notes表b:
objectid obname type视图:
create or replace view v_b as
select * from b where type=4用了视图的左联:
select a.id,
from a,v_b
where mff.ID=v_b.objectid(+)如何不用视,就一条SQL语句搞定????