我把SELECT文简化了一下:
---------------------------------------------------------------
Table :
MailSendReq (masrMailSendSeq,masrMailReqDate,masrMailSendDateTime ,
masrMailFmtID)
Cont(contMailAddr1,)
MiscNtfyMst(micnNtfyID ,micnProty,micnMailSendOKTimeFrom2 )
---------------------------------------------------------------SELECT A.masrMailSendSeq,A.masrMailReqDate,B.contMailAddr1,
FROM MailSendReq AS A with (READPAST,ROWLOCK,UPDLOCK)
LEFT OUTER JOIN Cont AS B ON (A.masrBrnchNo = B.contBrnchNo)
WHERE A.masrMailSendSeq =
(select top 1 masrMailSendSeq from MailSendReq AS A
INNER JOIN MiscNtfyMst AS C ON (C.micnNtfyID = A.masrMailFmtID)
WHERE A.masrMailSendDateTime IS NULL
AND C.micnMailSendOKTimeFrom2 IS NULL
ORDER BY C.micnProty,A.masrMailReqRcvDateTime ASC)
-------------------------------------------------------------------
---------------------------------------------------------------
Table :
MailSendReq (masrMailSendSeq,masrMailReqDate,masrMailSendDateTime ,
masrMailFmtID)
Cont(contMailAddr1,)
MiscNtfyMst(micnNtfyID ,micnProty,micnMailSendOKTimeFrom2 )
---------------------------------------------------------------SELECT A.masrMailSendSeq,A.masrMailReqDate,B.contMailAddr1,
FROM MailSendReq AS A with (READPAST,ROWLOCK,UPDLOCK)
LEFT OUTER JOIN Cont AS B ON (A.masrBrnchNo = B.contBrnchNo)
WHERE A.masrMailSendSeq =
(select top 1 masrMailSendSeq from MailSendReq AS A
INNER JOIN MiscNtfyMst AS C ON (C.micnNtfyID = A.masrMailFmtID)
WHERE A.masrMailSendDateTime IS NULL
AND C.micnMailSendOKTimeFrom2 IS NULL
ORDER BY C.micnProty,A.masrMailReqRcvDateTime ASC)
-------------------------------------------------------------------
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货