Alias

I have a MYSQL database that has data for a list management system. The attributes for a contact are all stored in an attribute table. For example, last name, first name etc are all attributes in the same table as different records. So if I want to get a list of the first and last names I need to use an alias. For example
SELECT lname.value, fname.value

From att_file as lname, att_file as fname ...
I attempted to edit the SQL after setting up the tables using the wizard. However, only the first instance was generated in the. Is there a way to have aliases.