Информация:
SELECT * FROM PurchTable_request NOTEXISTS JOIN * FROM RContractTable WHERE PurchTable_request.RequestId = RContractTable.RequestId NOTEXISTS JOIN * FROM PurchTable WHERE PurchTable_request.RequestId = PurchTable.RequestId NOTEXISTS JOIN * FROM PurchLine WHERE PurchTable_request.RequestId = PurchLine.RequestId NOTEXISTS JOIN * FROM AdvanceHolderTable WHERE PurchTable_request.RequestId = AdvanceHolderTable.RequestId
__________________
Лучше сделать и жалеть, чем жалеть что не сделал
|