mysql联合查询问题，各位帮我看看呗

Question

SELECT c.BarCode,c.cnName,c.certNumber,r.ispass,r.enname,r.holdercountry,r.sex,r.birthday,r.dateissue,r.expirationdate,r.placebirth,
r.placeissue,e.Sender,e.ExpNumber,e.createTime,
(SELECT CONCAT(d.createTime,'|',d.direction,'|',ifnull(d.reason,'-1')) FROM bjpj_passport_record d WHERE d.createTime
=(SELECT MAX(createTime) FROM bjpj_passport_record b WHERE d.barcode=b.barcode)) AS storage FROM bjpj_passport_checkcert c
JOIN bjpj_passport_express e ON c.ProjectID=e.ProjectID JOIN bjpj_passport_cert r ON c.BarCode=r.barcode
报错[Err] 1242 - Subquery returns more than 1 row，各位有懂的没？

Answer 1

SELECT CONCAT(d.createTime,'|',d.direction,'|',ifnull(d.reason,'-1')) FROM bjpj_passport_record d WHERE d.createTime
=(SELECT MAX(createTime) FROM bjpj_passport_record b WHERE d.barcode=b.barcode)

这句查询出来的条数大于1，所以结果集不能合并