+ 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;
2 Respuestas
+ 1
Hi,
Can you post columns of yours tables: customers and orders ?
Thx
Mbzh31
+ 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;