求一条sql语句

[luyuanshangao]

表：A
AID AName ASJName
1 编制 造价
2 审核 造价

表：B
BID MoneyMin MoneyMax
1 0 100
2 101 500
3 501 1000

表：C
CID AID BID Rate
1 1 1 5.0
2 1 2 4.5
3 1 3 4.0
4 2 1 4.0
5 2 2 3.5
6 2 3 3.0

要求得到结果如下：
AName ASJName 100以下 101-500 501-1000 -------（表B的数据做字段名）
编制 造价 5.0 4.5 4.0
审核 造价 4.0 3.5 3.0

拜托各位了 在线等

[wwwwb]

transform max(rate)
select AName,ASJName from (
SELECT *,a.MoneyMin & '-' & a.MoneyMax as ss from (tb a inner join tc b on a.bid=b.bid)
inner join ta c on c.AID=b.AID)
group by AName,ASJName
pivot ss

[ACMAIN_CHM]

TRANSFORM sum(Rate)
select AName,ASJName
from (C inner join A on c.aid=a.aid)
	inner join B on c.bid=b.bid
group by AName,ASJName
pivot b.MoneyMax