SQLize | PHPize | SQLtest

CREATE TABLE `sale_bd` ( `id_sdelka` int(11) NOT NULL, `prefix` varchar(50) NOT NULL, `client` varchar(20) NOT NULL, `date_sdelki` date NOT NULL, `sum_sdelka` decimal(50,2) NOT NULL, `marzha_sdelka` decimal(50,2) NOT NULL, `close` int(3) NOT NULL, `users` varchar(255) NOT NULL, `month` int(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `sale_post_bd` ( `id_post` int(50) NOT NULL, `id_sale_bd` int(50) NOT NULL, `sale_logist` int(3) NOT NULL, `company` varchar(255) NOT NULL, `num_chet` varchar(255) NOT NULL, `sum_cheta` decimal(50,2) NOT NULL, `upd` varchar(255) NOT NULL, `date_close` date NOT NULL, `sum_close` decimal(50,2) NOT NULL, `close` int(3) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SELECT `users`, `sum_sdelka`, `sum_close` FROM `sale_bd` LEFT JOIN ( SELECT `id_sale_bd`, sum(`sum_close`) as sum_close FROM `sale_post_bd` GROUP BY `id_sale_bd` ) `sales` ON `sales`.`id_sale_bd` = `id_sdelka`