1.
select id,sort,typename,typename_2 from advtst,tn8cClass_1,tn8cClass_2,tn8cClass_3
where advtst.sortid=tn8cClass_1.sortid and advtst.typeid=tn8cClass_2.typeid and advst.typeid_2=tn8cClass_3.typeid_2
2.
select id,(select sort from tn8cClass_1 where tn8cClass_1.sortid = a.sortid)as sort,... from advtst as a
其它两个同sort
select id,sort,typename,typename_2 from advtst,tn8cClass_1,tn8cClass_2,tn8cClass_3
where advtst.sortid=tn8cClass_1.sortid and advtst.typeid=tn8cClass_2.typeid and advst.typeid_2=tn8cClass_3.typeid_2
2.
select id,(select sort from tn8cClass_1 where tn8cClass_1.sortid = a.sortid)as sort,... from advtst as a
其它两个同sort
from advtst ad
inner join tn8cClass_1 c1 on c1.sortid = ad.sortid
inner join tn8cClass_2 c2 on c2.typeid = ad.typeid
inner join tn8cClass_3 c3 on c3.typeid_2 = ad.typeid_2
select a.id,b.sort,c.typename,d.typename2 from advtst a,tn8cClass_1 b,tn8cClass_2 c ,tn8cClass_3 d where a.sortid=b.sortid and a.typeid=c.typeid and a.typeid_2=d.typeid_2
from advtst a,tn8cClass_1 b,tn8cClass_2 c ,tn8cClass_3 d
where a.sortid = b.sortid
and a.typeid =+ c.typeid
and a.typeid_2 =+ d.typeid_2
from advtst a,tn8cClass_1 b,tn8cClass_2 c ,tn8cClass_3 d
where a.sortid = b.sortid
and a.typeid = c.typeid(+)
and a.typeid_2 = d.typeid_2(+)
自己再拿去试下拿个才是最合适的吧
where advtst.sortid=tn8cClass_1.sortid and advtst.typeid=tn8cClass_2.typeid and advst.typeid_2=tn8cClass_3.typeid_2
from advtst ad
inner join tn8cClass_1 c1 on c1.sortid = ad.sortid
inner join tn8cClass_2 c2 on c2.typeid = ad.typeid
inner join tn8cClass_3 c3 on c3.typeid_2 = ad.typeid_2
SORT=(SELECT SORT FROM tn8cClass_1 WHERE SORTID=T4.SORTID) ,
typename= CASE typeid
WHEN 0 THEN '无'
ELSE (SELECT TYPENAME FROM tn8cClass_2 WHERE TYPEID=T4.TYPEID) END,
typename_2=CASE typeid_2
WHEN 0 THEN '无'
ELSE (SELECT TYPENAME_2 FROM tn8cClass_3 WHERE TYPEID_2=T4.TYPEID_2) END
FROM advtst_fl T4 where t4.sortid!=0 and t4.gid_fl='0'