这样不是更简单:selectdistinct tr.fsReplyId,tr.fsReplyContent,tr.fsReplyPhone,tr.fsReplyTime from TReplytr,TMms tm where tm.fcPhone=tr.fsReplyPhone and tm.fsSenderId='0a187e99-012b-1000-e000-00cac0a803b8'--你原句中多了个as...
select distinct tr.fsReplyId as fsReplyId, tr.fsReplyContent as fsReplyContent, tr.fsReplyPhone as fsReplyPhone, tr.fsReplyTime as fsReplyTime from TReply as tr where ...