Andrew,
This should do it:
Select TABLE1.NAME
, CartesianArea(Overlap( TABLE1.OBJ, TABLE2.OBJ), "sq m")
"AREA_SQM"
From TABLE1, TABLE2
Where TABLE1.OBJ Intersects TABLE2.OBJ
Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
"For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet
muligt?
Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Tracey
Sent: Monday, September 18, 2006 5:17 PM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Querying
I have two tables - 1 consisting of 70 polygons and 1 consisting of 20
polygons. Both tables cover the same area, what I want to do is work out what
area or percentage of each of the polygons that is within another.
Does anyone know the syntax to do this?
Thanks
Andrew Tracey
Information Support Officer (GIS)
Information Team
Chief Executive Office
South Tyneside Council
Westoe Road
South Shields
NE33 2RL
Tel: 0191 4247561
E-Mail : [EMAIL PROTECTED]
************************************************************************************************
Please do not print this e-mail if you can help it - and help protect the
environment.
************************************************************************************************
This email and any files transmitted with it are confidential and intended
solely for the named recipient. If you have received this e-mail in error,
please immediately notify the sender by e-mail and delete from your system, you
are not permitted to disseminate, store, disclose or copy. E-mail transmission
cannot be guaranteed to be secure or error-free as they could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain viruses and
therefore the Council accept no liability for any such errors or omissions.
Views or opinions expressed in this email are solely those of the author and do
not necessarily represent those of the Council.South Tyneside Council, Town
Hall & Civic Offices, Westoe Road, South Shields, Tyne & Wear, NE33 2RL, Tel:
0191 427 1717, Website: www.southtyneside.info
************************************************************************************************
The Council's web site address is www.southtyneside.info
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
