Merging the fields in all the tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to merge all the fields in all the tables into one database.As in if
I have table A,B,C with primary key Y and each has fields 1,2,3,4.I want to
make a new database X with Y and 16 fields (4 fields in each table
respectively).
Is it possible to do this? If so how and also if there is a repetetion in
the field how can I deal with that?
I hope to hear from you Asap.
Thanks.
 
Why would you want to take a properly-normalized database and turn it into a
flat one? In other words, why would you take one that is right and make it
wrong?

It would make sense to build a query, form, or report that pulled data from
multiple tables and displayed it in a flat form. That is simply done by
including all the tables and fields in the query and making sure the
relationship between the tables is set properly.

Rick B
 
Hi,
In SAS,they want all the fields to be the same table.
I will try doing what you recommended.
Also I have fields with the same name in different tables.How can I add them?
Since there are' n ' number of fields,its not possible to manually rename
them.
Any suggestions?
Thanks
 
Back
Top