有大佬告诉我num为什么不明确吗 需要怎么改正

Question

create procedure cx @rs int,@rriqi1 date,@criqi1 date as --查询符合人数和日期的房间

declare @num char(7)

declare getCur cursor for

select num from fangjian,dengji

where fangjian.num=dengji.num and @rs=rs

and @rriqi1>criqi1 or @criqi1<rriqi1

open getCur

fetch getCur into @num

select num 房号,rs 可居住人数

from fangjian

where num=@num

close getCur

deallocate getCur

exec cx '1','2019-06-28','2019-07-05'

Answer 1

declare getCur cursor for select** num** from fangjian,dengji……

改成 fangjian.num