Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Urgent...... Please help

    Hi Experts,

    I have two schema in one database and all the tables are same in both schema with different data.I need to create another schema in which the all the tables have to be same but i need to view data from the other two schema that is in the third schema the tables should contain data from both the schema together.How can i achieve this?

    Please help me.

    Thanks in Advance.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    You can create VIEWs with UNION ALL for third schema, like this:

    CREATE VIEW third_schema.table_x AS
    SELECT * FROM first_schema.table_x
    UNION ALL
    SELECT * FROM second_schema.table_x

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    Thanks Tonkuma

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •