Post reply

script of vsingular view

  • February 11, 2009 at 4:16 am

    #206376

    Hi,

    Suppose we have two table, table1 having fields A, B, C and table2 having fields A,B,C,D,E,F. So, i want to create a script for view which cover all fields of table1 and table 2. I do not want to use UNION ALL method.

    I need a singular view so that we can take data from either table1 or table2 by changing table name only not by changing in script of view.

    Please send me script for that or is there any method.

    Thanks in advance.

  • February 13, 2009 at 10:51 am

    #943803

    I think you'll have to better describe what you want.

    Are the two tables related? What field are they joined on? Why not UNION ALL?

  • February 16, 2009 at 3:08 am

    #944384

    More description will be helpful and what would you want to take data either from table1 or table2?

    What you don't know won't hurt you but what you know will make you plan to know better

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply