×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Help out here with this update query.
I have table 1 and table2.
Table1 have my product discriptions and table 2 have new descriptions that I
want on tabel1
I need to update table1 with the values on the table2
I have this: (also provided from a this forum friend)
UPDATE EI_Gcfmd A SET A.DESEMD = B.DESEMD
WHERE EXISTS
(SELECT 1
FROM EI_GcfmdMS B
WHERE B.GFMEMD = A.GFMEMD AND
B.EMBEMD = A.EMBEMD AND
B.MODEMD = A.MODEMD AND
B.CIAEMD = A.CIAEMD AND
B.SOCemd = A.SOCemd)
What is missing here??
PLEASE HELP ME
Regards,
Marco
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
