this is part of one table hostname |  monitor | ip |  other fields... aaa |v | .... aaa |x | ... bbb | v | ... how can change the value of 'x' to 'v'  in the second row (when there is two diffrent value save it as V) i should save the ip because it can be different, the other fields also can be different the main problem it that I use join to this table by hostname which relies on the value of montior and something it got X when the real value is V maybe  can I use join if there is V at monitor? hope you undersatnd.  ... View more