SELECT * FROM Invoices inv WHERE EXISTS ( SELECT * FROM Daterange dr WHERE dr.Category = inv.Category AND inv.Deliverydate BETWEEN dr.DateBegin AND dr.DateEnd AND FlockNum BETWEEN Flbegin AND Flend)>
>Table: INVOICES > > Category Delivery date Quantity price > FFPP 01/10/2006 1.0000 59.0000 > FFPP 01/10/2006 1.0000 59.0000 > FFPP 10/20/2005 1.0000 12.2500 > FFPP 10/20/2005 1.0000 69.2200 > Commercial 10/20/2005 4.0000 7.5000 > FFPP 10/20/2005 2.0000 6.2500 > Organic 10/20/2005 1.0000 10.6200 > >Table: DATERANGE > Category Flock Num Date Begin Date End > FFPP 2064 01/25/2006 8/24/2006 > FFPP 2065 08/25/2006 10/25/2006 > FFPP 2066 10/26/2006 12/31/2006 > Organic 2064 02/25/2006 6/30/2006 > Organic 2065 07/01/2006 08/31/2006 > Organic 2066 09/01/2006 10/30/2006 > Commercial 2064 03/25/2006 9/20/2006 > Commercial 2065 09/21/2006 11/30/2006 > Commercial 2066 12/01/2006 01/31/2007 >>