not here, 1 for
pollutant here.
So that instead of the list I get now:
benzaldehyde
freon
formaldehyde
I would get:
lead 0
acetone 0
benzaldehyde 1
butane 0
freon 1
formaldehyde 1
How can I return an integer for positive values like this in a query?
--ja
--
--
MySQL General Mailing List
-
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 names, counties, etc. I can join the these
tables together
: [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 names, counties, etc. I can join the these
tables
[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 all
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 positive values
I am