有谁能帮助（sqlserver）

CREATE PROCEDURE [gettable]  @zkhi char(10)  AS
select zkh,xm,f1,f2,f3,f4,f5,f6,f7,f8,
 table21.km as km1,
 table22.km as km2,
 table23.km as km3
from table1
left  join table2 as table21 on table1.kc1 = table21.kc
      join table2 as table22 on table1.kc2 = table22.kc
      join table2 as table23 on table1.kc3 = table23.kc
where zkh=@zkhi
GO
哪位高手帮我看看问题在哪，无语法错，但就是出不来结果