select A.AID,A.ANAME,A.ASEX,B.BID,B.ANAME,B.Address
from A,B where A.BID=B.BID and (select count(0) as ll from A as AA where A.Bid=AA.Bid and A.Aid>=AA.Aid) <=4
order by A.AID ASC
from A,B where A.BID=B.BID and (select count(0) as ll from A as AA where A.Bid=AA.Bid and A.Aid>=AA.Aid) <=4
order by A.AID ASC
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货