Thanks @hfhbd. Can you elaborate? Your example doesn't seem to relate to my question. I was referring to queries that select the same fields on the same table, but with different where clauses. How can a view help this situation?
I realized I left that crucial bit about the same fields out of my original question. I've updated it.
h
hfhbd
02/15/2023, 5:16 PM
Okay, in this case just use a view with different where clauses to get the same type (the view).