MySQL Simple SELECT FROM WHERE Example

A simple example of using SELECT to retrieve data.
----------------------------------------------------------------------------

SELECT OProdID,firstname,lastname,title
FROM Orders,Customers,products
WHERE orders.OProdID=1
AND
customers.custid=orders.ocustid
AND
products.prodid=orders.oprodid;

------------------------------------------------------------------------