Hi guys,
i would like to make
create temporary table pagamentos SELECT d.name, SUM(advanced) AS total_advance, f.salario FROM data d JOIN empregados f ON f.name = d.name where MONTH(d.date) = 04 group by name;
and after select all
select * from pagamentos;
in a php script... could someone help me???
thanks
Danylo Iamaguchi
i would like to make
create temporary table pagamentos SELECT d.name, SUM(advanced) AS total_advance, f.salario FROM data d JOIN empregados f ON f.name = d.name where MONTH(d.date) = 04 group by name;
and after select all
select * from pagamentos;
in a php script... could someone help me???
thanks
Danylo Iamaguchi
Comment