Joining Tables
Consider the following query:
select * from stock, items
where stock.stock_num = items.stock_num
and items.quantityɭ
What we’re looking for is:
All of the items records with a quantity greater than 1
and their associated stock records.