SELECT NAME
FROM TABLE1 T1
JOIN TABLE2 T2
ON T1.SN = T2.SN
AND T2.SN in (2021,2023,2024,2028......)上面的SQL语句,我想让括号里的 "2021,2023,2024,2028......"内容作为动态查询的条件,
想用一个变量 sn_str 来代替 2021,2023,2024,2028......,这样只给 sn_str 赋值就行了,
可是sql语句错误,提示无效数字,应该怎么写啊??
FROM TABLE1 T1
JOIN TABLE2 T2
ON T1.SN = T2.SN
AND T2.SN in (2021,2023,2024,2028......)上面的SQL语句,我想让括号里的 "2021,2023,2024,2028......"内容作为动态查询的条件,
想用一个变量 sn_str 来代替 2021,2023,2024,2028......,这样只给 sn_str 赋值就行了,
可是sql语句错误,提示无效数字,应该怎么写啊??
FROM TABLE1 T1
JOIN TABLE2 T2
ON T1.SN = T2.SN
AND T2.SN in (&sn_str)
那应该怎么办呢?把SN转成字符型?怎么写??