SELECT users FROM(SELECT concat_ws(' ', ename, job) AS users FROM emp) emp2WHERE users LIKE 'SMITH CLERK'