I have a table, Devices, with various values under the column Type.
I wish to view all of the information regarding two of these values 'monitor' and 'valve'.
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?
If it is due to the command perhaps you can suggest a remedy.
Bob
------
create view p_id.trial
(P_ID_ID, Pipe_ID, Equipment_ID, Fluid_ID, Fluid, Type_, Function_, Device_ID, Device_Number, Association)
as select devices.p_id_id, pipe_id, equipment_id, process.fluid_id, process.fluid, devices.type_, devices.function_, device_id, device_number, devices.association
from p_id.devices, p_id.process
where devices.type_ = 'monitor'
or devices.type_ = 'valve'
and devices.fluid_id = process.fluid_id ;