Форум пользователей MySQL

select t.nomer, t1.`zakazchik` zakazchik ,
                t2.`name` name ,
                t3.`money` money ,
                t4.`prim` prim
                FROM database.table1 t left join
(select nomer, `zakazchik` from database.table1  ) t1 using (nomer) left join
(select nomer, `name` from database.table1  ) t2 using (nomer) left join
(select nomer, `money` from database.table1 where year(dateandtime)='2014' and month(dateandtime)='10' ) t3 using (nomer) left join
(select nomer, `prim` from database.table1 where year(dateandtime)='2014' and month(dateandtime)='10' ) t4 using (nomer)
where year(t.dateandtime) in (2014) and month(t.dateandtime) in (10) group by nomer;

select concat(prim1,' ',prim2,' ',prim3,' ',prim4) as prim from database.table1;