I have a cust.dbf and an orders.dbf. I want to create some SQL to purge older records. If the customer has not ordered anything in the last two years, I want to delete all his orders and his customer record. There is a unique CUST_KEY field in cust.dbf and orders.dbf. orders.dbf also has SEQ and ADD_DT fields.

Thanks

Brenda