Supplying Table Aliases

Earlier, in the section “Performing SELECT statements that Use Two Tables,” you saw that one way to qualify columns in queries that involve columns of the same name in different tables is to include the entire table name. The example in the earlier section used the following query:

SELECT products.name, product_types.name
FROM products, product_types
WHERE products.product_type_id = product_types.product_type_id;