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 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 For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
