Comments - Order Value per Region

1 year, 10 months ago Daniel Black

When you "JOIN" tables like this (and recommended syntax) don't list all the tables on the "FROM" line (avoid ever doing a "," join on the FROM line). The only table needed in the FROM clause is "Orders".

Apart from that to perform aggregates, a GROUP BY is usually needed though in this case i think its implicit.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.