Multiple table update query - Oracle Forums

TABLE1 NAME RATE TABLE2 NAME RATE1 DATE1 NAME RATE2 DATE2 NAME RATE3 DATE3 Can anyone help me to write a query which can update RATE in TABLE1 based ... Right krithika but you forgot group by Code sql: UPDATE table1 SET rate = (SELECT ...

www.club-oracle.com