select *
from
o_classfavorityinfo f
left outer join
(select i.duration,i.imagepath,p.appraisename,i.classid
(select i.duration,i.imagepath,p.appraisename,i.classid
from o_classinfo i, o_classappraiseinfo p, R_RESOURCEINFO r
where
p.classid = i.classid
and i.contentid = r.resourceid) b
on (f.classid=b.classid(+));
where
p.classid = i.classid
and i.contentid = r.resourceid) b
on (f.classid=b.classid(+));