On Sat, Dec 17, 2005 at 03:39:02PM -0800, Bob Pawley wrote: > The following gives me the information, but the rows are duplicated > from one to three times. I would like to see one row for each of the > values. I have attempted a number of variations but they all give me > similar duplication. > > Is this duplication due to the action of postgre as to the information > I've entered into the tables , or is it due to the structure of the > command? Have you tried using parentheses to group the OR expressions in the WHERE clause? where (devices.type_ = 'monitor' or devices.type_ = 'valve') and devices.fluid_id = process.fluid_id; -- Michael Fuhr
