Advertisement
Advertisement
| 06.16.2008 at 03:20PM PDT, ID: 23489820 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: |
SELECT tblContractorDocuments.ContractorID, luDocumentTypes.DocumentTypeID, luDocumentTypes.DocumentType, tblContractorDocuments.DocumentNumber, tblContractorDocuments.ExpireDate FROM luDocumentTypes LEFT JOIN tblContractorDocuments ON luDocumentTypes.DocumentTypeID = tblContractorDocuments.DocumentTypeID WHERE (((luDocumentTypes.IsInsurance)=True)) ORDER BY tblContractorDocuments.ContractorID, luDocumentTypes.DocumentType; |