SELECT all (*) or some columns from the given table.

SELECT column_1 , column_2 FROM [table]

SELECT columns from the given table.

SELECT [table_1].column_1 , [table_1].column_2 , [table_2].column_1 , [table_2].column_2 FROM [table_1] AS [table_1] LEFT JOIN [table_2] AS [table_2] ON [table_1].column_1 = [table_2].column_1