Posted By
Matthew Lee
08-23-2020 20:11
Found In
Egroup:
MapInfo Pro
\
view thread
I am having problems using nested functions while also using 'group by' within a simple SQL statement. The following SQL statement works ok: Select TABLE_A.REGION, TABLE_A.sort, sum(TABLE_B.COLA) "_2019_20", sum(TABLE_B.COLB) "_2020_21", sum(TABLE_B.COLC) "_2021_22" from TABLE_A, TABLE_B ...
|