Right Join

Question

You want to see the weekly delivery report. Write a query to output all customers and their orders in one table (fullname - age - address - amount)

My code:
SELECT customers.fullname, customers.age, customers.address, orders.amount
FROM customers RIGHT OUTER JOIN orders
ON customers.id = orders.customerid

Where am I wrong?

Answer 1

It worked
Thank you.

Answer 2

You have to switch the order in which you "outer join" like this

select customers.fullname, customers.age, customers.address, orders.amount
from orders right outer join customers
ON orders.customerid = customers.id

Answer 3

Elizabeth Makinde

Problem says to use RIGHT JOIN but There should be LEFT JOIN.

SELECT fullname, age, address, amount from customers c LEFT JOIN orders o ON c.id = o.customerid

Answer 4

Yes that should be left join

Answer 5

No possibility to solve this with Right join?

Answer 6

SELECT c.fullname, c.age, c.address, o.amount
FROM orders AS o RIGHT OUTER JOIN customers AS c
ON c.id = o.customerid

Works as a RIGHT JOIN. The above solutions are fine if you swap the order in which you call the table.

Answer 7

Heya this problem can only be solved by using the LEFT OUTER JOIN methord as you need to call all of the left table infomation, i.e the customer info regardless of where or not they have an order amount.

Answer 8

THAT WORKED! @ Kanyin Oni and Brian Alexander