Creating a view on multiple tables
Posted in 1995
Mark Steele — — source: Informix-list mailing list archive (1991-1998)
Currently I have a database that has numerous tables with the same schema. Basically they are the same table, split in to seperate tables by quarter. I am trying to create a view that will create the apperance of one all inclusive table. What I get instead is an error 531. Is it not possible? Can a view not be created on two similar tables? I don't want to combine the tables into one, for that would create an umanageable table of 40+ gig. -- | Mark Steele | | 74431,3327@compuserve.com | | It is nice to be important, but it is more important | | to be nice |