What's wrong with this? When I remove the count() function, it works fine.
SELECT r.id,
r.transaction_date,
0 as batchid,
r.telemrkt_company,
t.company_code,
count(*) as Cnt
FROM result_detail r
JOIN telemrkt_company t on r.telemrkt_company = t.id
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people