d
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 05, 2007 3:40 PM
> To: Jerry Schwartz; mysql@lists.mysql.com
> Subject: RE: return integer for positi
<[EMAIL PROTECTED]> wrote on 04/05/2007 02:46:43 PM:
>
> I have a table with a list of pollutants. I have a table of
> locations, site names, counties, etc. I can join the these tables
> together and get a list of of all the pollutants at a site. But,
> what I am really wanting is a list of
I am at a higher level than that. Here is my query:
SELECT distinct emt.group_name
FROM epa.aq_ambient_nad83 aq_,
epa.aq_ambient_pollutants pol,
epa.emtb_pollutant_group emt,
epa.pollutant pt
WHERE (aq_.siteid = pol.siteid)
AND (emt.group_code = pt.ambient_group_code)
AND (pol.paramcode
I'm not sure I quite follow. Is there a concentration for each location for
each of a master list of pollutants? What concentration would be considered
"not there"?
In any case, look at a construct like (ABS(concentration) <= ),
where -Original Message-
> From: [EMAIL PROTECTED] [mailto:[
