home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases
- Path: sparky!uunet!usc!news.service.uci.edu!network.ucsd.edu!munnari.oz.au!comp.vuw.ac.nz!newshost!srlncnc
- From: srlncnc@gopher.dosli.govt.nz (Chris Crook)
- Subject: FoxPro problem with outer join
- Message-ID: <1992Dec21.012636.28374@gopher.dosli.govt.nz>
- Sender: srlncnc@gopher.dosli.govt.nz (Chris Crook)
- Organization: Department of Survey and Land Information, New Zealand
- Date: Mon, 21 Dec 1992 01:26:36 GMT
- Lines: 31
-
-
- Can anyone offer any advice on how to solve the following problem in FoxPro
- (other than by using Paradox!).
-
- I have a one table (table1) with the following fields
-
- unique_key
- field1
- field2
-
- and a second table (table2) with the fields
-
- unique_key
- field2
-
- The key is common to the two tables, but table2 has only a subset of the
- key values that are present in table1. I would like to do is replace the
- field2 values in table1 for which there is a corresponding key in table2,
- leaving the rest of table1 untouched.
-
- I cannot do an SQL join because I would lose most of table1 (ie the records
- for which a key does not exist in table2). I would prefer to avoid using
- a SCAN on table2, because it could be SLOW!
-
- Have you any suggestions - is there anything obvious I have missed in the
- bulky manuals?
-
- Thanks in advance for any suggestions.
-
-
- Chris Crook
-