I have 2 tables:

Customer: customerid - int, pri-key,auto fname - varchar sname -varchar housenum - varchar street -varchar

Items: itemid - int,pri-key,auto type - varchar collectiondate - date releasedate - date customerid - int

I need a query which will get me all items that have a releasedate 3 days prior to (and including) the current date.

i.e The query should return customerid,fname,sname,street,housenum,type,releasedate for all items which have releasedate within (and including)3 days prior today

thanks in advance