Changes between Version 3 and Version 4 of Insert UGA into riversegment

Timestamp:

Sep 4, 2010 1:39:37 PM (15 years ago)

Author:

celine

Comment:

--

Insert UGA into riversegment

@@ -4 +4 @@
 {{{
 ALTER TABLE ccm21.riversegments ADD COLUMN uga character varying(25)
-select u.uga, u.wso_id, r.wso_id FROM uga2010.wso u, ccm21.riversegments r
-    WHERE u.wso_id = r.wso_id);
-
+UPDATE ccm21.riversegments SET uga = u.uga
+FROM ccm21.riversegments as r INNER JOIN
+        uga2010.wso as u  ON r.wso_id =u.wso_id;   
 }}}