select

Syntax:           

SELECT columns
FROM tables
WHERE predicates;

Example:

          SELECT *
          FROM suppliers
          WHERE city = 'Newark';

You can also use the select statement to retrieve fields from multiple tables.

SELECT orders.order_id, suppliers.name
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id;

You can select some fields from a table acoording to more than one conditions.