SELECT a.*,
case when (SELECT count(1) FROM TableA where ColumnA = a.ColumnB)=0 then 'Y'
else 'N'
end as Flag
FROM TableB a
where ColumnC = '7974'
sybase case when
最新推荐文章于 2021-12-29 13:45:42 发布
SELECT a.*,
case when (SELECT count(1) FROM TableA where ColumnA = a.ColumnB)=0 then 'Y'
else 'N'
end as Flag
FROM TableB a
where ColumnC = '7974'