Piotr ,

I'm a little new at this and don't know what you mean by DDL for the tables. Sorry. In updating the name_address table where the purpose is...

I appreciate your help and obviously I'm fairly new at this. I'll have to look more into what you said about ansi-compatable syntax. And why would using the...

that's got it, thank you for your help.

I've been working with the information you supplied, thank you but I'm just not getting what I think I need. I really only need this line:

and name.paid_thru <> subscriptions.payment_date

to...

Ah, thank you, that worked perfectly.

Very much appreciated.

Roy,

thank you but that is still only giving me the order_date that is exaclty 30 days + or - the subscriptions.paid_thru. I need any date that falls within that...