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

arrow
arrow
    全站熱搜

    Ching 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄