請教大家, 我有像以下的數據:

=Table A========
bid, date, price
==============
101, 2006-01-01, 200
101, 2006-01-02, 100
201, 2006-01-01, 310

=Table B========
bid, name
==============
101, Hotel A
201, Hotel B

我想得到 以 order by table A price desc 的方式列出 table B 的資料

我嘗試過:
SELECT b.name, a.price
FROM table_a as a, table_b as b
WHERE a.bid=b.bid
GROUP BY b.bid
ORDER BY b.price

並沒有效果.

請教各位知道要如何達成嗎?

謝謝