home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!wupost!cs.utexas.edu!uwm.edu!ogicse!emory!athena.cs.uga.edu!castor!howard
- From: howard@castor.cs.uga.edu (Les Howard)
- Newsgroups: comp.databases
- Subject: Help needed with a querry
- Message-ID: <1992Aug26.031803.1055@athena.cs.uga.edu>
- Date: 26 Aug 92 03:18:03 GMT
- Article-I.D.: athena.1992Aug26.031803.1055
- Sender: news@athena.cs.uga.edu
- Distribution: usa
- Organization: University of Georgia, Athens
- Lines: 24
- Originator: howard@castor
-
- I am trying to insert items into one field of a table generated by
- concatanating two fields in another table. Example of desired results.
-
- TABLE1 TABLE2
- LOT LOCATION LOTLOC
- -------- ---------- --------
- 081992 OpFloor 081992OpFloor
- 081992 Warehouse 081992Warehouse
- 082092 Warehouse 082090Warehouse
-
- I am envisioning using a querry probably based on something like.
- INSERT INTO TABLE2 (LOTLOC) SELECT LOT,LOCATION FROM TABLE1
- Does anyone have any good ideas on how to make this work?
- All the fields I want to concatanate are strings. I am using
- SQL in the querry manager from OS/2 1.3. Please reply to me by
- email as our news feed is occasionally flakey here.
-
- Thanks,
-
- --
- ===========================================================================
- Mr. Leslie P. Howard "Mr. Lehrer's muse (is) not
- University of Georgia fettered by such inhibiting
- howard@castor.cs.uga.edu factors as taste"...New York Times
-