多表查询（三张表）查询应该怎么写？

[menuasp]

CREATE PROCEDURE GetDetailszhong_year
(
@id int
)
AS
select zbgg_3.zb_xm as zb_xm,zbgg_3.zb_xmjl as zb_xmjl,zbgg_3.zb_cjfs as zb_cjfs,zbgg_3.zb_cjjg,zbgg_3.zb_cjgq as zb_cjgq,zbgg_3.zb_zlmb,zbgg_1.zb_isbn as zb_isbn,
zbgg_3.adddate as adddate,zbgg_3.zb_endtime as zb_endtime,zbgg_2.zb_xmlb as zb_xmlb,zbgg_2.zb_jsdw as zb_jsdw,
zbgg_3.zb_zbdw,zbgg_1.zb_title as zb_title from zbgg_1 inner join zbgg_3 on zbgg_1.id=zbgg_3.id on zbgg_1.id=zbgg_2.id
where zbgg_3.id=@id
GO

我上面的错误，我只会二张表查询，不会三张表以上的:9 不知道三张表进行链接查询应该怎么样写的，谢谢

错误提示：在关健字'on'附近有语法错误

[victorycyz]

from zbgg_1 inner join zbgg_3 on zbgg_1.id=zbgg_3.id
join zbgg_2 on zbgg_1.id=zbgg_2.id

[menuasp]

谢谢，

[chinaandys]

zbgg_3.zb_zbdw,zbgg_1.zb_title as zb_title from zbgg_1 inner join zbgg_3 on join zbgg_1.id=zbgg_3.id on zbgg_1.id=zbgg_2.id