I'm trying to create a superset of all records from previous years' work.
Is there a way to do this:
"Select all the records from table B that are not in table A" in order to
append these to the superset.
So far, all I've been able to get to work is:
1. select all the records the two tables have in common,
2. delete from table B,
3. save the remainder of table B to a new name,
4. close table B without saving the deletions,
5. then append the new table to table A.
If I try to do
"Select *
>From table A, table B
Where tableA.PID <> table B.pid"
MI gives an error about not having a proper join of the two tables.
Any ideas, is this even possible?
Gerald Kornelsen
GIS Technologist
City of Winnipeg
Property Assessment Dept
For those of you that need some travel inspiration, try downloading this
month's wallpaper from
http://www.ordsvy.gov.uk/wallpapers/currentmonth.htm
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
