来给我的SQL挑个错误。

Question

alter procedure GetregionInf
@employeecode varchar(20)
as
select c2.deptcode 
from (pub_employee as c1 left join pub_dept as c2
on c1.deptcode=c2.deptcode) as c3
where c2.deptno=substring(c1.deptcode,1,6) and c1.employeecode=@employeecode

Answer 1

on c1.deptcode=c2.deptcode) as c3
在第7行。系统提示的这句有问题，

Answer 2

select c2.deptcode 
from pub_employee as c1 left join pub_dept as c2
on c1.deptcode=c2.deptcode where c2.deptno=substring(c1.deptcode,1,6) and c1.employeecode=@employeecode

Answer 3

alter procedure GetregionInf
@employeecode varchar(20)
as
begin
select c2.deptcode 
from  pub_employee as c1 left join pub_dept as c2
on c1.deptcode=c2.deptcode 
where c2.deptno=substring(c1.deptcode,1,6) and c1.employeecode=@employeecode
end

Answer 4

create procedure GetregionInf
@employeecode varchar(20)
as
begin
select c2.deptcode 
from (pub_employee as c1 left join pub_dept as c2
on c1.deptcode=c2.deptcode) 
where c2.deptno=substring(c1.deptcode,1,6) 
and c1.employeecode=@employeecode
end

Answer 5

alter procedure GetregionInf
@employeecode varchar(20)
as
begin
select c2.deptcode 
from pub_employee as c1 left join pub_dept as c2
on c1.deptcode=c2.deptcode
where c2.deptno=substring(c1.deptcode,1,6) and c1.employeecode=@employeecode
end

Answer 6

create procedure GetregionInf
@employeecode varchar(20)
as
begin
select c2.deptcode 
from pub_employee as c1 left join pub_dept as c2
on c1.deptcode=c2.deptcode 
where c2.deptno=substring(c1.deptcode,1,6) and c1.employeecode=@employeecode
end