I did not get a chance to test the whole thing but try this... update test1 a set a.zona12 = (select coalesce(b.zona22,a.zona12) from test2 b where a.zona11 = b.zona21 AND b.zona23 = (select Max(c.zona23) from test2 c where a.zona21 = c.zona21 and b.zona22=c.zona22)) Let me know how that works out...
Announcement Announcement Module
No announcement yet.
Update with "order by" and "fetch first 1 rows only" Page Title Module
Move Remove Collapse