base_class主表,base_class_property子表
SELECT
(SELECT GROUP_CONCAT( b.`value` ) FROM `base_class_property` b WHERE b.`class_id`
= a.`id`)AS "品类属性"
FROM
`base_class` a WHERE a.`code` = '01'
base_class主表,base_class_property子表
SELECT
(SELECT GROUP_CONCAT( b.`value` ) FROM `base_class_property` b WHERE b.`class_id`
= a.`id`)AS "品类属性"
FROM
`base_class` a WHERE a.`code` = '01'