Select Code to Download

SELECT m.*,
    coalesce(sb.somecol, sd.somecol, tb.somecol, td.somecol) AS someco
+l
...
LEFT JOIN SDCCHDROP     sd ON m.NE = sd.NE AND m.KPI = 'SDCCHDROP'
LEFT JOIN TCHBLOCKING   tb ON m.NE = tb.NE AND m.KPI = 'TCHBLOCKING'
LEFT JOIN TCHDROP       td ON m.NE = td.NE AND m.KPI = 'TCHDROP'

my $dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver (*.mdb
+, *.accdb);dbq=D:\Project\Project\BSC_KPIMonitoring\CHN\E_BSC_KPIMoni
+torDB.mdb', undef, undef, { RaiseError => 1});

...
        print join(",", $kpis{$kpi}, $bsc, $thresh, "/$somecol");
    }
}