David What I assume you want is to make a new table, C, which has all of the fields common to both tables A and B, then to append all data from table A to C, and from table B to C - with all 'empty' fields from whichever source table being given a blank or zero value (depending on the data type of the field) in the target table.
That is - there is no relationship between any of the individual rows (records) in tables A and B. Also, that the fields that are common to both A and B have the same field names, datatypes, and constraints. It's done easily enough with MS Access, or could be done via 'raw' SQL statements using many different databases or their query designers. As you can imagine, because the field names and their datatypes and constraints can be infinitely varied, a visual designer / wizard is usually needed. The SQL can get a bit messy. Here's a tool you can try: www.ezydata.com - free fully-functional 30-day trial. Requires Access 2000 Runtime files (download from the same location). It has inbuilt wizards. The result will be an Access file. Ian Thomas GeoSciSoft - Perth, Australia -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Baker Sent: Monday, April 03, 2006 7:54 PM To: [email protected] Subject: [MI-L] Joining tables with very different structures I'm wondering if there is a tool hanging around that will do the following: I don't see any problem writing one myself if not, but no sense re- inventing the wheel. I have 2 tables with some common columns, but 1 table has some extra fields, and the other table has some different extra fields. What I want to do is to combine the tables so I end up with 1 new table which will have all the fields that exist in either of the 2 source tables. The new table should also have all the records from both tables with blanks (or zero) in the cells that didn't exist in the original tables. I don't think I'd be the first one to ever have the need to do this. Oh, and there is no spatial data in the tables - they are actually mdb/tab combinations - I don't have Microsoft Access otherwise I'd probably have better luck doing it there! :-) I've seen a couple of tools around but they only appear to join tables with identical structures. Dave _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
