select employees.employeeid,
'test_alue'=
case
when
employees.employeeid = 'ABCDE'
then ( Select count(field1) from tableA )
else ( Select count(field2) from tableB )
end
from employee
全站熱搜
select employees.employeeid,
'test_alue'=
case
when
employees.employeeid = 'ABCDE'
then ( Select count(field1) from tableA )
else ( Select count(field2) from tableB )
end
from employee
留言列表