hi All, I wanted to UPDATE multiple rows in a table by joining it with another table for identification of matching records (otherwise in the RDBMS world also commonly known as SET based UPDATE).
The idea is to update multiple records in one go , to downsize the lead time for each MR job to kick off. Is it supported or I am being greedy here with my wishlist ? Also, at an atomic level update as well, is there a way I can update a table without providing explicit variables (aka expression) in the WHERE clause. e.g.: I want to update one row in a table and in the where clause i wish to use a SELECT with other table to identify / match the record. Kindly drop a pointer to the syntax manual to look it up. Happy weekend ! -- Devopam Mittra Life and Relations are not binary
