SELECT [ ALL | DISTINCT ]
[ TOP expression [ PERCENT ] [ WITH TIES ] ]
{
*
| { table_name | view_name | alias_name }.*
| { column_name | [ ] expression | $IDENTITY | $ROWGUID }
[ [ AS ] column_alias ]
| column_alias = expression
} [ ,...n ]
FROM table_name | view_name alias_name
WHERE filter_criteria
ORDERBY ordering_criteria

SELECT * FROM shippers

Output
ShipperID   CompanyName         Phone
1        Speedy Express    (503) 555-9831
2        United Package    (503) 555-3199
3        Federal Shipping    (503) 555-9931

Above example shows that how can we retrieve all columns datafrom a single table. We can also retrieve datafrom more than one tablefor example 
SELECT * FROM shippers,products



SELECT productid,productname,unitprice FROM products

Output
ProductID    ProductName                    UnitPrice

1            Chai                            18.00
2            Chang                           19.00
3            Aniseed Syrup                   10.00
4            Chef Anton's Cajun Seasoning    22.00
5            Chef Anton's Gumbo Mix          21.35
6            Grandma's Boysenberry Spread    25.00
7            Uncle Bob's Organic Dried Pears 30.00
8            Northwoods Cranberry Sauce      40.00
9            Mishi Kobe Niku                 97.00
10           Ikura                           31.00

Above example explains how can we get selected columns/fields from particular table.We can also retrieve selected columns/fields from more than one tablefor 
example 
select ShipperID,CompanyName,ProductID,ProductName from Shippers,Products