拆分一句sql语句，不含子查询的。

[lianyi0927]

各位大虾，小弟有一句SQL语句需要拆分成不含子查询，水平有限，帮帮忙啊~
原句是：
SELECT AA.*,BB.leiming from(select a.*,b.chubanshe from (select * from Bookinfo)as a left join(select * from chubanshe) as b on (a.chubansheID=b.id)) as AA left join (select * from class) as BB on (AA.classID=BB.id)

[中国风]

select
	a.*,b.*,c.leiming
from 
	Bookinfo  a
left join
	chubanshe b on a.chubansheID=b.ID
left join
	class c  on c.ID=b.ID

[中国风]

select
	a.*,b.*,c.leiming
from 
	Bookinfo  a
left join
	chubanshe b on a.chubansheID=b.ID
left join
	class c  on c.ID=a.classID--这里定义列

[-狙击手-]

路过

[msdnlu]

select a.*,b.chubanshe,c.leiming
from
Bookinfo as a
left join
chubanshe as b
on
a.chubansheID=b.id
left join
class as c
on
a.classID=c.id