Database sql syntax, what is wrong with this sql code

Question

SELECT customer.first_name,
       customer.last_name,
       orders.order_number
FROM customer
     FULL OUTER JOIN orders ON customer.id = orders.customerid
ORDER BY customer.last_name;

Error SQL query: Documentation SELECT customer.first_name,customer.last_name,orders.order_number from customer full outer join orders on customer.id=orders.customerid ORDER by customer.last_name LIMIT 0, 25 MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'outer join orders on customer.id=orders.customerid ORDER by customer.last_nam' at line 3 — Golam Rabbani, Oct 13 '17 at 13:19
customer.id = orders.customer.id ??? I would need to see your table structures — Ryan Gadsdon, Oct 13 '17 at 13:20
i just wanted use full outer join with two table customer and order — Golam Rabbani, Oct 13 '17 at 13:22
Possible duplicate of [MySQL FULL JOIN?](https://stackoverflow.com/questions/7978663/mysql-full-join) — dbajtr, Oct 13 '17 at 13:26

score 0 · Accepted Answer · answered Oct 13 '17 at 13:27

0

SELECT customer.first_name,customer.last_name,orders.order_number from customer full outer join orders on customer.id=orders.customerid ORDER by customer.last_name;

Nothing wrong in this query just check your column name

answered Oct 13 '17 at 13:27

Rahul mishra

82
3

full join isnt supported – dbajtr Oct 13 '17 at 13:32
full outer join support in sql server – Rahul mishra Oct 13 '17 at 13:39

Database sql syntax, what is wrong with this sql code

1 Answers1