When writing a SQL Statment you will need to select data from a table. A table stores information about a collection of objects or entities. For example, if we were selling bicycles and accessories, we would need to keep a track of all the different products available. We would create a table to record each of these products. (See picture above)
So each row would be a record for each of these objects (bicycles). Each object will have a series of properties or attributes that describe that object. In our products table, these properties are stored in columns.
To retrieve this data using a SELECT statement we would use the code below where you separate each column you would like to retrieve using commas. Then you would specify FROM which table you would like to retrieve the records. In this case, the table name is Production.Product. This statement will return all the rows or records from the table. If we wanted to filter out specific records we would add a WHERE statement on the line following the FROM statement.