Karlsson on databases and stuff: Multicolumn UPDATE with Subquery the MySQL way

Karlsson on databases and stuff: Multicolumn UPDATE with Subquery the MySQL way

瀏覽:1072
日期:2025-12-12
Atul Yadav said... update ccistemp_db.FIR as a set UsedByStagging = 'S_FIR_FIRREGISTRATION' where a.FIRNo = (select fir.FIRNo from ccistemp_db.FIR fir left outer join ccistemp_db.FIRPlaceOfOccurence occPlc on fir.FIRNo = occPlc.FIRNo left outer join ......看更多