If these two tables have a common ID column you can use this column in this
way:
Select * From TABLEA
Where not ID In (Select ID From TABLEB)
Peter Horsbøll Møller
GIS Developer
Geographical Information & IT
COWI A/S
Rugårdsvej 55
DK-5000 Odense
Denmark
Tel +45 6313 5013
Direct +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail [EMAIL PROTECTED]
http://www.cowi.dk
> -----Original Message-----
> From: Wendy Tam [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 21, 2003 4:21 PM
> To: Map Info List (E-mail)
> Subject: MI-L Writing SQL Query in MapInfo
>
>
> Hi,
>
> I'm using MapInfo V5 and am trying to select records from
> TableA that are NOT in TableB.
>
> I think I know how to do this in SQL (select all records in
> Table A, then subtract the intersection between TableA and
> TableB), but how can I do this in the SQL dialog query box
> that comes up in MapInfo?
>
> I tried writing the SQL directly in a .QRY file, but then
> after looking at other MapInfo .QRY files, they have a
> different format.
>
> Thank you,
> Wendy
>
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine |
> www.directionsmag.com | To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> Message number: 9265
>
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9268
