DROP TEMPORARY TABLE IF EXISTS temp1;

CREATE TEMPORARY TABLE temp1
SELECT d.nid, d.title, d.circ, d.fonction, f.filepath
FROM deputes d, files f, image_attach ia
WHERE d.nid = ia.nid
&& ia.iid = f.nid;

SELECT d.nid, d.title, d.circ, d.fonction, f.filepath
FROM candidats d, files f, image_attach ia
WHERE d.nid = ia.nid
&& ia.iid = f.nid;

select * from temp2;