home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #31 / NN_1992_31.iso / spool / comp / database / 8651 < prev    next >
Encoding:
Internet Message Format  |  1992-12-22  |  667 b 
  1. Path: sparky!uunet!gatech!usenet.ins.cwru.edu!agate!spool.mu.edu!hri.com!noc.near.net!mars.caps.maine.edu!maine.maine.edu!dustin
  2. From: DUSTIN@MAINE.MAINE.EDU
  3. Newsgroups: comp.databases
  4. Subject: Re: FoxPro problem with outer join
  5. Message-ID: <92357.132059DUSTIN@MAINE.MAINE.EDU>
  6. Date: 22 Dec 92 18:20:59 GMT
  7. References: <1992Dec21.012636.28374@gopher.dosli.govt.nz>
  8. Organization: University of Maine System
  9. Lines: 7
  10.  
  11. Upon looking @ my manuals, the UPDATE command should work for your purposes
  12.  
  13. SELECT table1
  14. UPDATE ON unique_key FROM table2 REPLACE table1.field2 WITH table2.field2 RANDO
  15. M
  16. This should update the fields in table1 with corresponding data in table2.
  17. JD
  18.