SELECT NAME
FROM TABLE1 T1
JOIN TABLE2 T2
ON T1.SN = T2.SN
AND T2.SN = '2303'
我这样写只能查询 T2.SN = '2303' 的一个结果,
我想一次同时查询出 SN = 2021,2022,2023,2024......对应的NAME结果集。
请教高手SQL语句怎么写?
FROM TABLE1 T1
JOIN TABLE2 T2
ON T1.SN = T2.SN
AND T2.SN = '2303'
我这样写只能查询 T2.SN = '2303' 的一个结果,
我想一次同时查询出 SN = 2021,2022,2023,2024......对应的NAME结果集。
请教高手SQL语句怎么写?
FROM TABLE1 T1,T2
where T1.SN = T2.SN
SN in( 2021,2022,2023,2024...)
SELECT wm_concat(NAME) name
FROM TABLE1 T1,T2 直接不行吗?