تالار گفتمان nCIS.ir

CREATE TABLE `list` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `code` varchar(10) NOT NULL,
 PRIMARY KEY (`id`)
)



CREATE TABLE `detail` (
  `id` int(11) NOT NULL,
  `code` int(11) NOT NULL,
  `price1` varchar(10) NOT NULL,
  `price2` varchar(10) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) 

SELECT * FROM `list` WHERE `code` in (select `code` from `detail` where `status` = '1'
group by `code`
HAVING  sum(`price1`) !=  sum(`price2`))

SELECT * FROM `list`
WHERE `code` IN (
    SELECT `code` FROM (
        SELECT `code`, SUM(`price1`) AS `sum1`, SUM(`price2`) AS `sum2`,`status`
        FROM `detail`
        WHERE (`status`='1')
		GROUP BY `code`
        HAVING (`sum1`<>`sum2`)
    ) AS `temp`
);