求一SQL语句,

[疯狂秀才2018]

我有三个表
A表:AID,ANAME
DATA:1,AAA
2,BBB
3,CCC
.......
B表:BID,BNAME,AID
DATA:1,1A,1
2,2A,1
3,3A,2
C表:BID,CTIME
DATA:1,2006-3-18 15:59
2,2006-3-18 14:50

三张表联合查询,查出的结果为日期最晚的一条数据,BNAME不允许重负

[zlp321002]

--不知道你,要什么样的结果.??

SELECT A.Aint,A.ANAME,B.Bint,B.BNAME,B.AID,C.BID,C.CTIME
FROM A表 A LEFT JOIN B表 B
ON A.Aint=B.AID LEFT JOIN C表 C
ON B.Bint=C.BID

[Comer]

真的看不懂楼主想要什么

[Comer]

如果说不清你想要的结果，那就把你的真实数据列举一下，然后列出你要的结果

[happywang11]

SELECT A.AID,A.ANAME,B.Bid,DISTINCE B.BNAME,B.AID,C.BID,C.CTIME
FROM A INNER JOIN B ON A.AID = B.AID
INNER JOIN C ON B.BID = C.BID
ORDER BY C.CTIME DESC

[aniude]

MARK

[zhaoanle]

--试试

select a.aid,a.aname,b.bname,b.bid,c.ctime from 表A a,表B b,表C c where not exists(select 1 from 表C where bid=c.bid and ctime>c.ctime)
and a.aid=b.aid and b.bid=c.bid

[da21]

试试这样，应该行的!
Select A.AID, A.ANAME, B.BID, B.BNAME, C.CTIME
FROM A, B ,C
WHERE A.AID = B.BID AND B.BID = C.BID
AND C.CTIME = (SELECT MAX(CTIME) FROM C )
;