|
David,
This is a bit of a workaround. Of course if there is a better
way, I'd be very happy to learn of it!
Do an SQL select
Select * from both tables where Table1.common
field=table2.common field
Save query as new table - query 1.
Invert selection to pick up records from Table1 that weren't
selected previously. Save that as Query table 2
Do sql select again.
Select * from both tables (listing table 2 first this
time...)
Where Table2.common field=table1.common field
Without saving query, invert selection and save this result as
query table 3.
You should now be able to append rows from Query table 2 to
Query table 1 and once you have altered the table structure for query table 3 to
reflect the structure of query table 1, you can then append rows from table 3 to
table 1.
When I do this, I end up with a table that has Table 1
columns, followed by table 2 columns all in one table. Obviously the rows
appended from query tables 2 and 3 will have some cells with Null values (empty
cells).
Hope this helps,
Alistair.
>>> "David Baker" <[EMAIL PROTECTED]> 3/04/06 21:53:38 >>> 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 ***************************************************************** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is strictly prohibited. The information contained in this email, including any attachment sent with it, may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone collect on Australia +61 1800 198 175 or by return email. You should also delete this email, and any copies, from your computer system network and destroy any hard copies produced. If not an intended recipient of this email, you must not copy, distribute or take any action(s) that relies on it; any form of disclosure, modification, distribution and/or publication of this email is also prohibited. Although Queensland Health takes all reasonable steps to ensure this email does not contain malicious software, Queensland Health does not accept responsibility for the consequences if any person's computer inadvertently suffers any disruption to services, loss of information, harm or is infected with a virus, other malicious computer programme or code that may occur as a consequence of receiving this email. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. **************************************************************** |
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
