[trudel]

Там еще аналогично и deliveryOrderTable присоединяется. Т.е. мне надо
VendTableJour full join CustTableJour on 1=2
full join DeliveryOrderTable on 1=2
...
Where (VendTableJour.invoiceDate between dtn and dte)
Or (CustTableJour between dtn and dte)
Or(DeliveryOrderTable.Date between dtn and dte)