请教一条联合查询的sql语句

[dayer]

主表A,字段Id,Aname,..
从表B,字段Id,Bname,Aid,...
从表的数据表C,字段Cid,date,Bid
想要根据A表的Id查询出Aname,Bname,date,并且date以降序排列且只有这条最新的数据

谢谢各位

[tkbtkl]

select a.Aname,b.Bname,d.date
from a,b,
(select cid,max(date)
from c
group by cid) d
where a.aid=b.aid and a.aid=d.cid

[tkbtkl]

select a.Aname,b.Bname,d.date
from a,b,
(select bid,max(date)
from c
group by bid) d
where a.id=b.aid and b.id=d.bid

[i9988]

select
a.Aname,
b.Bname,
c1.date
from
a,b,c c1
where
a.id=b.aid and
b.id=c.bid and
c1.date=(
select
max(date)
from
c
where
bid=c.bid
)

[i9988]

select
a.Aname,
b.Bname,
c1.date
from
a,b,c c1
where
a.id=b.aid and
b.id=c.bid and
c1.date=(
select
max(date)
from
c
where
bid=c1.bid
)

[i9988]

select
a.Aname,
b.Bname,
c1.date
from
a,b,c c1
where
a.id=b.aid and
b.id=c.bid and
c1.date=(
select
max(date)
from
c
where
bid=c1.bid
) and
a.id=指定的值
order by
c.date desc

[dayer]

多谢，测试可以通过的，
但因为实际中有多个主从表，我用到了很多的INNER JOIN，能不能用比较更好点的方法实现呢？
在等等，然后结贴

[dayer]

星期六了，祝周末好啊
^_^