SQL RIGHT OUTER JOIN

Question

Can someone please tell me what I have done wrong

OUT PUTTING EVERYTHING BUT ONE NAME

SÉLECTcustomers.fullname,customers.age,customers.address,orders.amount FROM customers RIGHT OUTER JOIN orders ON customers.id = orders.id;

Generating nothing but I know I need to combine columns

SÉLECT CONCAT (* from orders)customers.fullname,customers.age,customers.address,orders.amount FROM customers RIGHT OUTER JOIN orders ON customers.id = orders.id;

Answer 1

Hi,
Can you post columns of yours tables: customers and orders ?
Thx
Mbzh31

Answer 2

Thank you for responding i actually figured it out
Switched the from clause to orders right outer join customers then changed the on statement to customers.id = orders.customerid;