select A.*,BName,CName,DName ,F.*,G.*,H.* from A ,B,C,D,F,G,H where AStatus=1 and
A.Bid=B.Bid and A.cid=C.cid and A.did=D.did and A.aid=*F.aid and A.aid=*g.aid and a.aid=h.aid
A.Bid=B.Bid and A.cid=C.cid and A.did=D.did and A.aid=*F.aid and A.aid=*g.aid and a.aid=h.aid
a left join b on a.bid=b.bid
left join c on a.cid=c.cid
left ......
where a.AStatus=1
因为当F,G,H中部都有的同一AId时,就不会被列出来应该用到join的