I'm using MYSQL 5.6 and have 3 tables:
1. Customers (Cutomer_id, Customer_Name)
2. Order1 (Order_Id1, Customer_id)
3. Order2 (Order_Id2, Customer_id)
I need to write a query to count the number rows from Order1 and Order2 group by Customer_Id.
The result should be like:
Customer_Id Customer_Name Number of Orders (From Order1 and Order2) 0000000000 xxxxxxxxxxxxxxx 50
With best regards.