|
joe8915
Starting Member
USA
9 Posts |
 Posted - 10 February 2003 : 16:40:20
|
Can anyone tell me why I am getting this message. I have copy the SQL statement below
SELECT TblProclog.*, tblPayEstimates.DtdRec, tblPayEstimates.DtdSign, tblPayEstimates.Pay_ID, tblPayEstimates.[Pay Est Number], tblPayEstimates.[Contractor Name_ID], tblPayEstimates.[Paid To Date], tblPayEstimates.[Invoice Number], TblProclog.ContractType
FROM TblProclog LEFT JOIN tblPayEstimates ON TblProclog.ID = tblPayEstimates.Pay_ID
WHERE (((tblPayEstimates.DtdRec) Is Not Null) AND ((tblPayEstimates.DtdSign) Is Null));
Thanks |
Edited by - ruirib on 10 February 2003 17:10:49 |
|
Topic Locked
