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.
