Need to put this in one table
Multiple query from multiple tables
(select name from table1) as Name, (date from table2) as Date, (select name, sum(qty) as QTY from table3 group by name ) as QTY, (select name from table3) as NameY Result new table column1 (Name), Column2(Date), Column3(QTY), Column4(NameY)