I have two tables in which “id” is constant.
Table 1 columns are: id, value_of
The value_of column has the values “2010/07/10/name1_abc”
Table2 columns are id, key,value_id
value_id values are represented as “2010-07-11 00:00:00”
Now I have to change the value in table1.
select value-of from table1 cv, table2 c where c.id=cv.id and key=28
and c.id=153
This will return the value 2010/07/15/lon-abc.
Using the query I have check, if the values of “value_of” column and value_id are equal. If it is not equal then, I should not update “value_of”.
i.e
“value_of” in table1 is “2010/07/10/name1_abc” and value_id is “2010-07-11 00:00:00”,
then value_of should be changed to “2010/07/11/name1_abc”
if YYYY, MM, DD are same in two tables then I should not update the value or else I have to replace it.