PurchTable purchTable; VendInvoiceJour vendInvoiceJour; VendInvoicePurchLink vendInvoicePurchLink; VendPackingSlipPurchLink vendPackingSlipPurchLink; ; while select vendInvoiceJour join vendInvoicePurchLink where vendInvoicePurchLink.purchId == vendInvoiceJour.PurchId && vendInvoicePurchLink.invoiceId == vendInvoiceJour.InvoiceId && vendInvoicePurchLink.internalInvoiceId == vendInvoiceJour.InternalInvoiceId && vendInvoicePurchLink.invoiceDate == vendInvoiceJour.InvoiceDate join purchTable where purchTable.PurchId == vendInvoicePurchLink.origPurchId notexists join vendPackingSlipPurchLink where vendPackingSlipPurchLink.origPurchId == purchTable.PurchId { ... }