I have 2 IDENTICAL tables (TableName_A and TableName_B) that I use in
my production system. I have a table (TableState) with 1 row and 1
column whose value determines which table is the "active set". (ie,
TableState had a column named TableSet whose value is either 'A' or
'B').

I would like to setup a view that can allow me to write queries with
"from Tablename" where the selection of A or B is done in the
background on the fly.

Is this possible?

Thanks,
Mark