At 15:09 10/08/1999 , Diana Hicks wrote: >I have third party application software where the location master file has >two fields for the key. The first field is 16 alphanumeric and the second >field is 2 numeric. The other files that reference this location master >file has a single key of 18 alphanumeric. The problem is I need to link to >the location master file to get the most important information, address. >Our users have a report writer using ODBC to access these files on the >AS/400. > >Does anyone know how or if I can join these files? All responses will be >appreciated. Thanks. Should be able to do something like this: SELECT STUFF1, STUFF2, STUFF3 FROM LOCMST A JOIN NUTHER B ON SUBSTR(B.KEY,1,16) = A.KEY1 AND SUBSTR(B.KEY,17,2) = DIGITS(A.KEY2) Pete Hall firstname.lastname@example.org http://www.execpc.com/~pbhall +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.