I have four tables, each with a dteRefresh field which contains a date value.
Is there a way of returning the maximum date within the four tables in a single query.
I could do it by running a union query and then creating another query to return the maximum date, but I'm hoping there's a way of...