How come I get so many Smiths in this query (using the Week 2 lecture database)?
There's only 26 orders and 4 customers named Smith. Yet I get 104 rows as a result?
SELECT orders.order_numb, customers.customer_last_name
FROM orders, customers
WHERE customers.customer_last_name like "smith";
Attachment:- WEEK2_ACCESS2000.zip