Subquery returns more than 1 row字面意思为,子查询返回了多行结果查看一下子查询,是不是返回了多行结果加入limit语言限制一下返回结果SELECT iMSG_ID,cUSR_FROM_NAME,cUSR_FROM_NAME =(SELECT cUSER_DISP_NAME from MSG_TBL left join MEMBER_INFO_TBL on MEMBER_INFO_TBL.cUSR_NAME =msg_tbl.cUSR_FROM_NAME limit 0,1) as otherFROM MSG_TBL WHERE iMSG_ID='5'...