Select a.cStatus, a.cInvoiceNo, a.dInvoiceDate, b.cReportNo, b.cCenReptNo, b.iCenReviseNo, b.vProjectNo, b.vProjectSeqNo, a.vCustCode, a.cCurrency,b.cReportNo,b.cCenReptNo,
b.dLoginDate,a.vCustCode,b.vBuyer,b.dGenRept, b.dFaxRept,a.vBillNo,b.vBillTo,b.nvCustCont,a.cInvoiceNo,a.dInvoiceDate,a.cCurrency,a.nBillAmt,a.nLocAmt, a.vPRCInvoiceNo,
a.dPRCInvoiceDate,vPRCLastUpdBy,dPRCLastUpdOn,
Case a.bFinalSettle When 1 then 'Y' else 'N' End, a.nCreditAmt,a.cCreditNoteNo,dCredit,vCreditReason,b.dFOC,c.vUserName,b.vFOCReason,a.dSuspend,d.vUserName,e.vUserName,
a.dLastUpd,a.cLastUpdBy
from a_AppHeader b
left join a_BillHeader a on b.cReportNo = a.vReportNo
left join b_UserTable c on b.cFOCBy=c.cUserID
left join b_UserTable d on a.cSuspendBy=d.cUserID
left join b_UserTable e on a.cIssueBy=e.cUserID
Where b.dCancel Is Null and b.bSubContractJob=0 and b.dFaxRept between '12/08/2009 9:17:31' and '01/07/2010 9:17:32'
Order By b.cReportNo DESC
b.dLoginDate,a.vCustCode,b.vBuyer,b.dGenRept, b.dFaxRept,a.vBillNo,b.vBillTo,b.nvCustCont,a.cInvoiceNo,a.dInvoiceDate,a.cCurrency,a.nBillAmt,a.nLocAmt, a.vPRCInvoiceNo,
a.dPRCInvoiceDate,vPRCLastUpdBy,dPRCLastUpdOn,
Case a.bFinalSettle When 1 then 'Y' else 'N' End, a.nCreditAmt,a.cCreditNoteNo,dCredit,vCreditReason,b.dFOC,c.vUserName,b.vFOCReason,a.dSuspend,d.vUserName,e.vUserName,
a.dLastUpd,a.cLastUpdBy
from a_AppHeader b
left join a_BillHeader a on b.cReportNo = a.vReportNo
left join b_UserTable c on b.cFOCBy=c.cUserID
left join b_UserTable d on a.cSuspendBy=d.cUserID
left join b_UserTable e on a.cIssueBy=e.cUserID
Where b.dCancel Is Null and b.bSubContractJob=0 and b.dFaxRept between '12/08/2009 9:17:31' and '01/07/2010 9:17:32'
Order By b.cReportNo DESC
是不是你的日期问题,连接没问题吧