create a temporary table

[parallax]

hi guys,

how could i create and send this
[HTML]SELECT d.name, d.missing, f.salario, (SELECT SUM(advanced) FROM data d2 WHERE d.name=d2.name) AS AdvanceSum from data d JOIN empregados f ON f.name = d.name where MONTH(d.date) = 4 group by name;[/HTML]
to a temporary table??
i have to add this select in a temporary table and make a calculation between the sum(advanced) and the f.salario but i have no idea of how to write the code...

thanks

[pbmods]

hi guys,

how could i create and send this
[HTML]SELECT d.name, d.missing, f.salario, (SELECT SUM(advanced) FROM data d2 WHERE d.name=d2.name) AS AdvanceSum from data d JOIN empregados f ON f.name = d.name where MONTH(d.date) = 4 group by name;[/HTML]
to a temporary table??
i have to add this select in a temporary table and make a calculation between the sum(advanced) and the f.salario but i have no idea of how to write the code...

thanks

CREATE VIEW `View_PayrollOrWhatever` AS SELECT d.name, d.missing, f.salario, (SELECT SUM(advanced) FROM data d2 WHERE d.name=d2.name) AS AdvanceSum from data d JOIN empregados f ON f.name = d.name group by name;
 
CREATE TEMPORARY TABLE `Temp_Data_PayrollOrWhatever` SELECT * FROM `View_PayrollOrWhatever` where MONTH(d.date) = 4;

http://dev.mysql.com/doc/refman/5.0/en/create-view.html
http://dev.mysql.com/doc/refman/5.0/...ate-table.html (look towards the bottom)