Accessing 2 tables with 1 name

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 Received on Tue Jul 01 2003 - 15:05:16 CDT