Hi Old Pedant,
Thanks for the suggestion.
However, I'm not sure that will work, because the values in the site table are the keys of the records on the wind direction table, rather than the compass degrees.
What I'm trying to do is to join to the wind direction table to use the degrees on there to do the comparison with the parameter value.
- your quick and easy, yet powerful solution for managing your membership site sales, downloads and affiliates.