I am OK with queries when it involves one table but not so great with multiple table and filtering. I have the following issue i hope someone can help me with:
All Linked by AccountNumber field in all tables.
This is a customer database with all accounts and all their respective service requests and invoices. Looking for a query to provide a list of accounts that meet the following:
And has had a service order or invoice in the last three years.
Also would like query for the inverse of this; list of accounts that DON’T meet this filter.