Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to ... Dot notation uses the period character to separate the table and column. If the column appears only in one ...