有三张表,A,B,C
A结构 AID ANAME AID为主键
B结构 AID BID BNAME BID为主键,AID为外键
C结构 AID BID CID CNAME CID为主键,AID,BID为外键我想写一条查询表C的全部记录的语句,要求按如下排序
AID1 BID1 CID* CNAME
AID1 BID2 CID* CNAME
AID1 BID3 CID* CNAME
AID1 BID4 CID* CNAME
AID2 BID1 CID* CNAME
AID2 BID2 CID* CNAME
AID2 BID3 CID* CNAME
AID2 BID4 CID* CNAME
.......
AIDn BID1 CID CNAME
AIDn BID2 CID CNAME
AIDn BID3 CID CNAME
AIDn BID4 CID CNAME即先按AID从小到大排序,分成大块,再对相同的AID中按BID从小到大排序
请问sql语句应该怎么写
A结构 AID ANAME AID为主键
B结构 AID BID BNAME BID为主键,AID为外键
C结构 AID BID CID CNAME CID为主键,AID,BID为外键我想写一条查询表C的全部记录的语句,要求按如下排序
AID1 BID1 CID* CNAME
AID1 BID2 CID* CNAME
AID1 BID3 CID* CNAME
AID1 BID4 CID* CNAME
AID2 BID1 CID* CNAME
AID2 BID2 CID* CNAME
AID2 BID3 CID* CNAME
AID2 BID4 CID* CNAME
.......
AIDn BID1 CID CNAME
AIDn BID2 CID CNAME
AIDn BID3 CID CNAME
AIDn BID4 CID CNAME即先按AID从小到大排序,分成大块,再对相同的AID中按BID从小到大排序
请问sql语句应该怎么写
c.*
from
a,b,c
where
a.AID=b.AID and a.aid=c.aid and b.bid=c.bid
order by
c.aid ,bid
c.*
from
a,b,c
where
a.AID=b.AID and a.aid=c.aid and b.bid=c.bid
order by
c.aid ,c.bid