Referring to Other Columns in Conditions

You can refer to another column in the query from within a cell. For example, you type the following condition into the LNAME column of the EMPLOYEE table to test for a last name equal to a first name:

=fname