在查询-Operand中包含一列

Question

我有这个查询，它给了我错误

操作数应包含一列。但我现在需要两个专栏。有人能帮我吗？

SELECT `business`.`id` AS business_id,
       `business`.`name` AS business_name,
       `business`.`address`,
       `business`.`address2`,
       `business`.`city`,
       `business`.`state`,
       `business`.`zipcode`,
       `business`.`lat`,
       `business`.`lon`,
       `service`.`id` AS ser_id,
       `service`.`name` AS service_name,
       (SELECT price, `price_verified`.`comments`
          FROM `price_verified`
               LEFT JOIN `price`
                  ON `price_verified`.`price_id` = `price`.`id`
         WHERE     `price`.`service_id` = ser_id
               AND `price_verified`.`status` = 1
        ORDER BY `price_verified`.`date_verified` DESC
         LIMIT 1)
  FROM service
       LEFT JOIN `business` ON `service`.`business_id` = `business`.`id`
 WHERE `service`.`business_id` = 1

谢谢

Answer 1

正如错误消息所述，在子查询中只能有一个结果列。

要么您必须连接子查询结果，要么对每个列有两个子查询。

像这样：

(SELECT  concat(price,`price_verified`.`comments`)  as result
FROM `price_verified`  LEFT JOIN `price` ON `price_verified`.`price_id`=  `price`.`id` \n\
                WHERE `price`.`service_id`=ser_id  AND `price_verified`.`status`= 1  ORDER BY `price_verified`.`date_verified` DESC LIMIT 1)