× 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.


  1.  Home
  2. MIDRANGE-L
  3. April 2009

RE: SQL Inserting from one table to another with different column names

Allen,
I believe that 'SQL where exists' will update ONE field/column per SQL
statement:


Your request: STEP 1 update C1
update c090401a/file1 A set a.C1=
(select b.C4 from c090401a/File2 B where
a.sddoco= b.sddoco and a.sddcto=b.sddcto and a.sdlnid=b.sdlnid )
where exists
(select * from c090401a/File2 b where
a.sddoco= b.sddoco and a.sddcto=b.sddcto and a.sdlnid=b.sdlnid )
++++++++++++++++++++++++++++++++++++++
STEP #2 update C2
update c090401a/file1 A set a.C2=
(select b.C4 from c090401a/File2 B where
a.sddoco= b.sddoco and a.sddcto=b.sddcto and a.sdlnid=b.sdlnid )
where exists
(select * from c090401a/File2 b where
a.sddoco= b.sddoco and a.sddcto=b.sddcto and a.sdlnid=b.sdlnid )
+++++++++++++++++++++++++++++++++++++++++++
STEP 3: blank out C5
update c090401a/file1 A set a.C5= ' '
where exists
(select * from c090401a/File2 b where
a.sddoco= b.sddoco and a.sddcto=b.sddcto and a.sdlnid=b.sdlnid )

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.