Read this SQL tutorial to learn when to use SELECT, ... table1.column1 and table2.column1 are used to combine or join the tables, but only values from table2.column2 are returned.