Skip to content

Latest commit

 

History

History
6 lines (5 loc) · 362 Bytes

using_aliases.md

File metadata and controls

6 lines (5 loc) · 362 Bytes

Using aliases

We alias members and golf_centers as m and c respectively, so when we are referencing columns from those two tables, all we have to do is to prefix the column name with the alias of that table followd by a dot (.).

SELECT m.id, m.first_name, m.last_name, c.centre_num FROM members m, golf_centres c WHERE m.centre_num = c.id;