|
I know the following sql syntax is not correct (I'm new at attempting SQL) but this is what I want to do. I am attempting to pull the field acnm_name1 from rugr80dat/pmspag00 table and put it into the bus_name field in the jacfiles.agcy_ext table. These 2 files are tied by agcy_mco=mco and agnm_agcy = agcy. Any help (without laughing) would be appreciated. UPDATE jacfiles.agcy_ext r1 SET bus_name = acnm_name1 WHERE EXISTS (SELECT 1 FROM rugr80dat.pmspag00 r2) WHERE r1.mco = r2.agnm_mco and r1.agcy = r2.agnm_agcy John A Candidi Rutgers Insurance Companies IT Director - AS/400 Manager 856-779-2274
As an Amazon Associate we earn from qualifying purchases.
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
