Jon,
I assume that both contour plots we generated using Vertical Mapper and thus
you have grids representing these two variables. If this is the case then
the Grid Query tool in Vertical Mapper can provide this functionality.
James Harvie
Vertical Mapper Product Manager
Northwood Technologies Inc.
43 Auriga Drive, K2E 7Y8
Nepean, Ontario, Canada
613-224-2020
-----Original Message-----
From: Jon Rees EG CEFAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 3:10 AM
To: 'Mapinfo-l @ directions Mag'
Subject: MI-L Intersections of contours
Listers,
I've created two contour plots using Vertical Mapper (of spring tidal
current and suspended load in the North Sea) and wish to find areas which
have high currents (> 100 cm/s) and high suspended load ( > 40 mg/l). I've
tried to use the SQL query :
Fields {*}
Tables {Spring_contour,sld_contour}
Where {Spring_contour.Upper > 100 and sld_contour.Upper > 40}
Group {}
Order {}
Into {highstress}
(Syntax is correct)
(both tables have lower and upper contours)
However, I get the error :
No join specified between tables spring_contour and sld_contour. Invalid
join condition in WHERE clause.
I've checked that there is a region that overlaps both high velocities and
high concentrations.
Any ideas?
Thanks in advance
Jon Rees
CEFAS, Lowestoft, UK.
Email: [EMAIL PROTECTED]
Web: www.cefas.co.uk
_______________________________________________________________________
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.
