SELECT CONCAT(firstname," ",lastname," ",CASE dept_id
WHEN '1' THEN 'ITD'
WHEN '4' THEN 'FMAD'
WHEN '6' THEN 'GCSMD'
WHEN '7' THEN 'SSHED'
WHEN '10' THEN 'GPD'
ELSE 'Z_ISDC'
END AS ayam) as staffname
FROM ost_staff
我想要从
staffname
得到的输出是"John Doe ITD",但是它没有生效。