You appear to have no value at all in
eid
, so the string just evaluates to:
DELETE emp.*, emplogin.* FROM tbl_employee_details as [emp] LEFT JOIN tbl_user_login_access as [emplogin] ON emp.emp_id = emplogin.emp_id where emp.emp_id =
SQL quite rightly throws a hissy fit and complains.
Check the variable content in the debugger, and please, stop doing it like that. Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.