SQL In子句值

Question

我有以下SQL

Select * 
from PS_VENDOR 
WHERE VENDOR IN ('111','222','333','444') 

其中 444 VENDOR 不存在。但是当我运行 SQL 时，我应该从 IN CLAUSE 中获取所有 4 行所有供应商，对于 444，只需填充空白或“X”

我尝试了以下方法，但它不起作用

Select * 
from PS_VENDOR 
WHERE NVL(VENDOR IN ('111','222','333','444'), 'X');

Answer 1

使用 CTE 来保持你的值(value)观，左连接

with V1 as
(
select '111' as VV from dual
union all
select '222' as VV from dual
union all
select '333' as VV from dual
union all
select '444' as VV from dual
)

select VV, PS_VENDOR.*

from V1
left join PS_VENDOR 
  on VENDOR = VV