RE: return integer for positive values

2007-04-05 Thread Jerry Schwartz
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

Re: return integer for positive values

2007-04-05 Thread ddevaudreuil
<[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

RE: return integer for positive values

2007-04-05 Thread jabbott
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 05, 2007 2:47 PM > > To: mysql@lists.mysql.com > > Subject: return integer for positive values > > > > > > I have a table with a list of pollutants. I have a table of > > locations, site

RE: return integer for positive values

2007-04-05 Thread Jerry Schwartz
IL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 05, 2007 2:47 PM > To: mysql@lists.mysql.com > Subject: return integer for positive values > > > I have a table with a list of pollutants. I have a table of > locations, site names, counties, etc. I can join the th

return integer for positive values

2007-04-05 Thread jabbott
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 all the pollutants with a integer field, zero for pollutant not