|
Dear All,http://search400.techtarget.com/tip/0,289483,sid3_gci1027756_mem1,00.html
Dear All,
Thanks a lot for all the helpful replies.
I also found an exact example for what I need to do at this link:
another file where unique field matching is possible. In the example, I
Here is a snippet:
"You can easily update a field in one file with SQL by using a field in
updated from.
COALESCE covers the situation where one field may contain a NULL.
Note that the field to be updated must be compatible with the field
FILE2 B WHERE A.COMP = B.COMP AND A.CLAIM = B.CLAIM)"
UPDATE FILE1 A SET A.LOADDT = (SELECT COALESCE(B.LOADDT, A.LOADDT) FROM
list
Thanks and have a nice week-end
Dina
From: David.FOXWELL@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Date: Fri, 26 Feb 2010 12:57:55 +0100
Subject: RE: Joining two same tables in different libraries using SQL
-----Message d'origine-----UPDATE update_table U
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de dina ramzy
SELECT A.FLD12, B.FLD12
FROM LIB1.TABLE1 A, LIB2.TABLE1 B
WHERE
A.KEYFLD1 = B.KEYFLD1 AND
A.KEYFLD2 = B.KEYFLD2
Now I want to update table A and set FLD12 to be the same as
the corresponding one in table B (A.FLD12 = B.FLD12)
Could you please help me in writing this SQL statement.
SET myfield = (SELECT M.MyField FROM MasterTable M WHERE U.MyKey=
M.MyKey) WHERE U.MyKey IN (SELECT U.MyKey FROM MasterTable M)
And read the valuable lesson from Charles Wilt to myself here :
http://archive.midrange.com/midrange-l/200904/msg00775.html
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
--To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.