This discussion is archived
2 Replies Latest reply: Nov 12, 2012 5:20 AM by 973776 RSS

sinlge select query in different schemas for same table(Indentical Structu)

973776 Newbie
Currently Being Moderated
Scenario :

Table XYZ is created in Schema A
After an year, the old data from the previous year would be moved to different schema. However in the other schema the same table name would be used.

For eg

Schema A contains table XYZ with data of 2012 yr
Schema B contains table XYZ with data of 2011 yr
Table XYZ in both the schemas have identical structure.

So can we fire a single select query to read the data from both the tables in effective way.
Eg select * from XYZ where date range between 15-Oct-2011 to 15-Mar-2012.
However the data resides in 2 different schema altogether.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points