Anyone know the query for the WHERE Clause using object name.

For example, I want to use the WHERE Clause where the object name Equals 'E_Name'

SELECT *
FROM EMPLOYEE
WHERE E_Name = 'E_Name'

I know that for ASP this query works.

WHERE WORK_ID ='" & objRS("ID") & "'

Just a correction. The WHERE WORK_ID ='" & objRS("ID") & "' query works. I am referencing another alias name from another dataset. Not from the field name.

Thanks though.