Welcome Guest, Not a member yet? Register   Sign In
combining two rows wit the Query Builder

Thanks Beer. I ended up merging the rows with this statement.
$sql="INSERT INTO substantially_all_render_temp2 SELECT '',PR, taxyear,
sum(research_dol) as research,
sum(support_dol) as support,
sum(supervision_dol) as supervision,
sum(research_dol) as total_POE_dol,
sum(research_dol)+sum(support_dol)+sum(supervision_dol) as total_BC_wages_dol,
sum(research_dol)*100/ (sum(research_dol)+sum(support_dol)+sum(supervision_dol)) as percent_substantially_all
FROM substantially_all_render_temp
GROUP BY BC, taxyear";
proof that an old dog can learn new tricks

Messages In This Thread
RE: combining two rows wit the Query Builder - by richb201 - 07-08-2021, 07:14 AM

Theme © iAndrew 2016 - Forum software by © MyBB