Creating view of a table from another user
Posted on 2002-06-03
i had a user "sim" representing the main office having following tables
acc_glday,cashes,day_one,day_two andday_sub . for obtaining some consolidated
reports from all branches i had created another user "conso " and created all
the above tables on that user area also.
i am importing data from all branches including the main office into tables in
i would like to create a view by the union of tables of user sims and tables
of user conso on the user conso. if i can do taht it is possible to avoid
importing data from user sim to user conso and data redundancy can be
please help me for creating such a view of any of above mentioned tables on the
user area conso.