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

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

瀏覽:748
日期:2025-09-30
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 ......看更多