Instruction: Give me all customers with their selling items even if they are not selling any items.
SELECT customers.name, items.name
FROM customers
LEFT OUTER JOIN items ON customers.id=seller_id
| name | name |
|---|---|
| Henry Jackson | Google Pixel 3 |
| Harry Potter | NULL |
| Sherry Gibbons | Samsung Ear Pods |
| Jedi Simpson | Beer |
| Luke Skywalker | Alexa |
| Darth Vader | Google Home |
No comments:
Post a Comment