Hi Sarah, If the tables have identical structure, you can build a seamless table to open them as one layer.
If the tables have different structure, you can merge them by first finding the minimum column set that all contain (nb! they need to have compatible column types), build a new table with this column set and append all data from all tables into this new table by issuing multiple "insert into" statements, e.g. (with 4 common columns): INSERT INTO newtable (mycol1,mycol2,mycol3,mycol4) SELECT mycol1,mycol2,mycol3,mycol4 FROM origtable1 INSERT INTO newtable (mycol1,mycol2,mycol3,mycol4) SELECT mycol1,mycol2,mycol3,mycol4 FROM origtable2 INSERT INTO newtable (mycol1,mycol2,mycol3,mycol4) SELECT mycol1,mycol2,mycol3,mycol4 FROM origtable3 etc. You can "package" these statements as a WOR, and use "Add Workspace" to run them automatically. A good text editor and some copy/pasting will make your file fast. The order of columns in the list is arbitrary as long as it's the same everywhere. The list of tables to add is of course also arbitrary. Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ http://www.gispro.biz/ http://hjem.get2net.dk/lars-online/ WGS84: 10.26'40"E 55.20'20"N ----- Original Message ----- From: "Hooper Sarah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 4:45 PM Subject: MI-L Multiple tables into one > Hello, > > I am using separate tiles (tables) of Streetmap landbase data but would like > to somehow make all the tiles into one table. As they are not editable it's > not that straight forward. Any solutions, or help is much appreciated. > > Regards > Sarah > > > > > *********************************************************************************** > The contents of the e-mail and any transmitted files are confidential and intended > solely for the use of the individual or entity to whom they are addressed. Transport for London hereby exclude any warranty and any liability as to the quality or accuracy of the contents of this email and any attached transmitted files. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. > > If you have received this email in error please notify [EMAIL PROTECTED] > > This footnote also confirms that this email message has been swept for the presence > of computer viruses. > *********************************************************************************** > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 8349 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8350
