Hi,
update TableA
set TableA.Image = TableB.Image from ( select Image from TableA where dataAreaid = 'USMF' and imagetype = 1) as TableB
where dataAreaid = 'USF1' and imagetype = 1
Regards,
Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
Friday, October 18, 2024
SQL _ Update statement using selection of same table or different table
X++ code to submit the pending vendor invoices
Hi,
VendInvoiceHeaderWorkflow::submitToWorkflow(VendInvoiceInfoTable::find(541879755462212), "Submitted by Integration");
Regards,
Subscribe to:
Posts (Atom)