apply query after concate two column

[deep raj]

how can we apply query on column combined with two columns
i use it
SELECT CONCAT(emp_fname,' ',emp_lname) AS emp_name
FROM employee_personal
where emp_name NOT IN (select emp_name from task_allocation where proj_name='abc')

but it shows error on "where emp_name NOT IN

[Hussein Baghdadi]

Sir this isn't a JSP question...

[moderator removed the dude word]

[Ireneusz Kordal]

A column alias definied in the SELECT clause of the query can be only used in the ORDER BY clause of this query,
it cannot be used in any other clauses.
This should work:

SELECT CONCAT(emp_fname,' ',emp_lname) AS emp_name
FROM employee_personal
WHERE CONCAT(emp_fname,' ',emp_lname) NOT IN (select emp_name from task_allocation where proj_name='abc') 

[Tom Reilly]

Don't you also need to add the CONCAT to the subselect?

WHERE CONCAT(emp_fname,' ',emp_lname NOT IN (select CONCAT(emp_fname,' ',emp_lname) from task_allocation where proj_name='abc')   

[deep raj]

Thank you Ireneusz Kordal and Tom Reilly