hello,
try to use
Select a.col1,b.col1,areaoverlap(a.obj,b.obj) from a,b where a.obj
intersects b.obj
Good luck,
Mikhail
-----Original Message-----
From: deva <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 25 ������� 1999 �. 19:56
Subject: MI Regarding spatial query..
>Dear MI users,
> I tried to work on a query which gives the overlapped area between
> objects in two table..The query,i used was
> Select a.col1,b.col1,overlap(a.obj,b.obj) from a,b where a.obj
>intersects b.obj
>
>The above query returns all object
>in "a" table which intersects with Objects in "b" table instead of the
>overlapped region..
> Is there any way to get the overlapped region using spatial
>query..
>please help me ..
>Thanks in advance..
>
>regards luv,
>deva
>
>___________________________________________________________________________
___
>
>
>
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]