I've been looking at some tutorials on the MySQL site http://sqlcourse2.com/select2.html.
The following:
SELECT *produces the same results as:FROM items_ordered'Tent';
WHERE item =
SELECT customerid,order_date,item,quantity,price FROM items_ordered
WHERE item = 'Tent';
What is * doing in this statement.