SQL basics - Join tables from THENEWBOSTON

 Instruction: Add seller information to the items table. (You need to join two tables by finding the relation between two tables.) 

SELECT customers.id, customers.name, items.name, items.cost

FROM customers, items

WHERE customers.id=seller_id

ORDER BY customers.id

id	name	name	cost
1	Laura Kwon	Chocolate	10
2	Bucky Parker	Books	20
3	Noah Burger	Pixel 10	30
4	David Smith	Laptop	40
5	Teresa Jackson	Yoga pants	50
6	Gary Foster	Monitor	60