Instant SQL Formatter (dpriver.com)<\/a><\/li>\n<\/ul>\ncon JOIN org \u8cc7\u6599\u8868\u4e4b\u5f8c\uff0c\u60f3\u8981\u5e36 sale \u5c0d\u61c9\u7684\u4e00\u5c0d\u591a\u92b7\u552e\u7d00\u9304\u3002\u6839\u64da\u9700\u6c42\u53ef\u4ee5\u90fd\u4f7f\u7528 JOIN \u4f86\u9023\u63a5\uff0c\u4e4b\u5f8c\u5728\u7528\u7a0b\u5f0f\u4f86\u8655\u7406\u986f\u793a\uff0c\u4e0d\u904e\u9019\u6a23\u7a0b\u5f0f\u96e3\u5beb\uff0c\u5982\u679c\u53ef\u4ee5\u628a\u92b7\u552e\u7d00\u9304\u4e5f\u8b8a\u6210\u4e00\u500b\u6b04\u4f4d\u5c0d\u61c9\u5230\u7d00\u9304\u5c31\u597d\u4e86\uff0c\u9019\u6642\u5c31\u53ef\u4ee5\u4f7f\u7528 GROUP_CONCAT()<\/p>\n
SELECT a.*,\r\n GROUP_CONCAT(sale.name) AS name,\r\n GROUP_CONCAT(sale.price) AS price\r\nFROM `con` a\r\n INNER JOIN org b\r\n ON a.org_id = b.id\r\nWHERE a.xxx = '1'\r\nGROUP BY a.id\r\nORDER BY a.id DESC<\/pre>\n\u9019\u6a23\u6703\u67e5\u8a62\u51fa 2 \u500b\u6b04\u4f4d\uff0c\u5fc5\u9808\u81ea\u884c\u4f7f\u7528 key \u4f86\u5b9a\u4f4d\uff0c\u4e0d\u60f3\u9019\u9ebc\u9ebb\u7169\u7684\u8a71\u53ef\u4ee5\u6574\u5408\u6210\u4e00\u500b JSON\uff0c\u50cf\u9019\u6a23<\/p>\n
SELECT a.*,\r\n CONCAT('[', GROUP_CONCAT(\r\n CONCAT('{\"name\":\"', sale.name, '\",'),\r\n CONCAT('\"price\":\"', sale.price, '\"}')\r\n ),\r\n ']')\r\n AS detail\r\nFROM `con` a\r\n INNER JOIN org b\r\n ON a.org_id = b.id\r\nWHERE a.xxx = '1'\r\nGROUP BY a.id\r\nORDER BY a.id DESC<\/pre>\n\u5982\u6b64\u5c31\u53ef\u4ee5\u6d88\u6ec5\u842c\u60e1\u7684\u591a\u5c64 SELECT \u8cc7\u6599\u5eab\u67e5\u8a62\u7de9\u6162\u554f\u984c<\/p>\n
--<\/p>\n
<\/p>\n
<\/div>\n