SELECT
`one`.*,
IFnull (
sum(two.class_two_qty),
0
) AS `tnum`
FROM
`nb_goods_class_one` AS `one`
LEFT JOIN `nb_goods_class_two` AS `two` ON `one`.`class_code` = `two`.`class_one_code`
WHERE
`one`.`status` = 1
GROUP BY
`two`.`class_one_code`
ORDER BY
`one`.`sort` ASC,
`one`.*,
IFnull (
sum(two.class_two_qty),
0
) AS `tnum`
FROM
`nb_goods_class_one` AS `one`
LEFT JOIN `nb_goods_class_two` AS `two` ON `one`.`class_code` = `two`.`class_one_code`
WHERE
`one`.`status` = 1
GROUP BY
`two`.`class_one_code`
ORDER BY
`one`.`sort` ASC,
`one`.`id` ASC
SELECT
`one`.*,
IF(
sum(two.class_two_qty) is null,
0,
sum(two.class_two_qty)
) AS `tnum`
FROM
`nb_goods_class_one` AS `one`
LEFT JOIN `nb_goods_class_two` AS `two` ON `one`.`class_code` = `two`.`class_one_code`
WHERE
`one`.`status` = 1
GROUP BY
`two`.`class_one_code`
ORDER BY
`one`.`sort` ASC,
`one`.`id` ASC