+ 1

SQL RIGHT OUTER JOIN

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;

2nd Feb 2022, 3:42 PM
Tevin
2 ответов
+ 1
Hi, Can you post columns of yours tables: customers and orders ? Thx Mbzh31
3rd Feb 2022, 7:29 PM
MBZH31
MBZH31 - avatar
+ 1
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;
3rd Feb 2022, 7:35 PM
Tevin