Answered You can hire a professional tutor to get the answer.
QUESTION
I keep getting an Error 1064 in MySQL and it says that there is an error in my SQL syntax from the below entry: SELECT C.CustomerID, C.CustomerName,...
I keep getting an Error 1064 in MySQL and it says that there is an error in my SQL syntax from the below entry:
SELECT C.CustomerID, C.CustomerName, O.OrderDate, O.TotalOrderAmount
FROM CUSTOMER C
LEFT JOIN [ORDER] 0
ON C.CustomerID=O.CustomerID
UNION
SELECT C.CustomerID, C.CustomerName, O.OrderDate, O.TotalOrderAmount
FROM CUSTOMER C
RIGHT JOIN [ORDER] 0
On C.CustomerID-O.CustomerID;
Can I please get some assistance on how to correct this?
