nkuebelbeck
VIP Member
Jde c api sql having clause
I can't seem to locate a way to include a HAVING sql command
trying to do something like this via C API
select sdshpn,count(distinct sddoco),sum(sditwt),avg(sdan8) from libary.f42119 left join library.F42019 on sddoco=shdoco where sdADDJ>=116001 and sdADDJ <=116366 and shptc='CWO' and sddcto='M1' group by sdSHPN HAVING count(distinct sddoco)>1;
Is this possible?
I can't seem to locate a way to include a HAVING sql command
trying to do something like this via C API
select sdshpn,count(distinct sddoco),sum(sditwt),avg(sdan8) from libary.f42119 left join library.F42019 on sddoco=shdoco where sdADDJ>=116001 and sdADDJ <=116366 and shptc='CWO' and sddcto='M1' group by sdSHPN HAVING count(distinct sddoco)>1;
Is this possible?
Last edited: