34,590
社区成员
发帖
与我相关
我的任务
分享
select (case (select COUNT(*) from banks where banksCode='YJT062') when 0 then (select empName from emply where empNo='YJT062') else (select banksName from banks where banksCode='YJT062') end) takeAddress
后怎么看都感觉特别麻烦 所以来论坛里向大佬们请教。 受益匪浅哇selet bankCode from banks where bankCode=@code
union all
selet empName from emply where empName=@code
-- 两个表联合查询
select * from (
select bankCode,bankName from banks union all
select empNo,empName from emply ) t
where bankCode = @code