Hi Gerald,
You can't directly select the rows from th table B that are not in table A.
I think the way to do this is :
- create a new column in the table B named "common" (char 2)
- Update table B :
Table to update "Table B"
Column to update "common"
Get value from table "table A" join (where PID from TableB matches PID
from TableA)
Calculate value
Of : expression...: "ok"
- Select * From TableB Where common = "ok"
- Delete this records, delete the column common,
- Table/Append Rows to table...Append table : TableB to table : TableA
Regards,
__________________________________________________
Sophie Coubes
Conseillere en Geomatique
GIS Consultant
KOREM Inc. (http://www.korem.com)
GEOdiffusion de l'information
GEObroadcasting your information
__________________________________________________
680, Boul. Charest Est
Quebec (Quebec) CANADA G1K 3J4
tel.: 418 647-1555
fax : 418 647-1666
Telephone sans frais : 1 888 440-1MAP
__________________________________________________
Meilleur nouveau partenaire Mapinfo 2000 - Amerique du Nord
Best Mapinfo New Partner 2000 - North America
__________________________________________________
Push'n'See! Developed by KOREM http://www.pushnsee.com
The Web-Mapping Software for Entreprise-wide Depoyment
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Kornelsen,
Gerald
Envoyé : 4 juin, 2001 12:35
À : MapInfo-list (E-mail)
Objet : MI-L SQL question
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.
_______________________________________________________________________
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.
