mysql union all from one table create from join and another table
I have one question please
I would like to do "union all" through union to two tables but one is
created with a join of 3 tables, is it possible?
exemple
1table create by join
(SELECT numfattmiele, datafattmiele, idclifattmiele, codsfusofattmiele
,nomegiacesfusofattmiele, kgsfusofattmiele, resparzcodsfusofattmiele,
resparznomesfusofattmiele, FROM fattmiele AS FM
JOIN dettsfusofattmiele AS DS ON FM.idfatt = DS.idfatt JOIN
giacesfusofattmiele AS GS ON DS.idfatt = GS.idfatt)
and after with
UNION ALL
normal select another table
Select idconf, codconf..etc.. from confmiele...from confmiele
some can help me please thanks...
No comments:
Post a Comment