问题如下:select par from tb_table1 where id=1;
得到par的值 between 100 and 500怎么样把 between 100 and 500带到下面的SQL?select * from tb_table2 where price (select par from tb_table1 where id=1)实现类似于:select * from tb_table2 where price between 100 and 500
得到par的值 between 100 and 500怎么样把 between 100 and 500带到下面的SQL?select * from tb_table2 where price (select par from tb_table1 where id=1)实现类似于:select * from tb_table2 where price between 100 and 500
--在where条件里用in
select * from tb_table2 where price in (select par from tb_table1 where id=1)
select * from tb_table2 where price IN (select par from tb_table1 where id=1)
方法不行,提示:将数据类型 nvarchar 转换为 numeric 时出错。price是数字类型的
select * from tb_table2 where price IN (select par from tb_table1 where id=1)
方法不行,提示:将数据类型 nvarchar 转换为 numeric 时出错。price是数字类型的
select * from tb_table2 where price IN (select par from tb_table1 where id=1)
方法不行,提示:将数据类型 nvarchar 转换为 numeric 时出错。price是数字类型的