View to look at current table
Posted on 2011-10-06
We will be have two tables table_a table_b
day1 load table_a with currentdatetimestanp don't touch table_b
day2 load table_b with currentdatetimestamp don't touch table_a
so when table_b is finshed sumhow we create a view which should be intellegent to know
now switch to table_b and ignore table_a so basic idea is view which will be union
of two tables should just look for currenttimestamp table and ignore the other table
as these tables don't have key and we don't want to distrub business.
Is this possibel?