select 项目种类,项目类型,项目名称,规格,单位,单价,id from tb where id in (select 项目ID from tb_2 where tb_2.id=12397);
在tb_2.id=后面只能填数字,如果换成变量的话,老是提示 "语法错误或违反访问规则 "
正确的语句该怎么写啊
------解决方案--------------------
declare @ID int
set @ID = 12397
select 项目种类,项目类型,项目名称,规格,单位,单价,id from tb where id in (select 项目ID from tb_2 where [email protected])
------解决方案--------------------
declare @ID int
set @ID = 12397
exec ( 'select 项目种类,项目类型,项目名称,规格,单位,单价,id from tb where id in (select 项目ID from tb_2 where tb_2.id= '[email protected]+ ') ')