-- The syntax for the AND condition is:
 
SELECT columns
FROM tables
WHERE column1 = 'value1'
AND column2 = 'value2';
 
-- The AND condition requires that each condition be must 
-- be met for the record to be included in the result set. 
-- In this case, column1 has to equal 'value1' and column2 
-- has to equal 'value2'.
 
 
 
-- Example #1
 
-- The first example that we'll take a look at involves a very 
-- simple example using the AND condition.
 
SELECT *
FROM suppliers
WHERE city = 'New York'
AND TYPE = 'PC Manufacturer';
 
-- This would return all suppliers that reside in New York 
-- and are PC Manufacturers. Because the * is used in the select, 
-- all fields from the supplier table would appear in the result 
-- set.
 
 
 
--Example #2
 
-- Our next example demonstrates how the AND condition can be 
-- used to "join" multiple tables in an SQL statement.
 
SELECT orders.order_id, suppliers.supplier_name
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
AND suppliers.supplier_name = 'IBM';
 
-- This would return all rows where the supplier_name is IBM. 
-- And the suppliers and orders tables are joined on supplier_id. 
-- You will notice that all of the fields are prefixed with the 
-- table names (ie: orders.order_id). This is required to 
-- eliminate any ambiguity as to which field is being referenced; 
-- as the same field name can exist in both the suppliers and 
-- orders tables.