Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Join query if no referential integrity bw two tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kethepalli vagdevi

New User


Joined: 07 Sep 2006
Posts: 2

PostPosted: Thu Sep 07, 2006 12:41 pm    Post subject: Join query if no referential integrity bw two tables
Reply with quote

There are two tables .
Table 1 contains 3 fields say A (primary key), B, C
Table 2 contains 2 fields say X,Y - no primary key.

We need to join these two tables.
There is no referential integrity between these tables.
Tha values in field A(char 3) are same as values in first 3 characters of field X(char 8).
and we need to join , table 1 and table 2 based on field A (of size 3) with only first 3 characters of field X(of size 8) .

There are more than 1 record for field A in table 2(field X).

eg : Field A has value 'MNP'
Field X has value 'MNP00045'
Back to top
View user's profile Send private message

sarunkumaar

New User


Joined: 31 Aug 2006
Posts: 15
Location: Chennai, India

PostPosted: Thu Sep 07, 2006 1:37 pm    Post subject: Join Query
Reply with quote

Use substring to match the keys.

SELECT COLUMNS_NEEDED FROM TABLE01 T1, TABLE02 T2
WHERE SUBSTR(T2.X,1,3) = T1.A
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need suggestion on how to force refer... subratarec DB2 1 Wed Apr 25, 2018 9:22 am
No new posts How to force a select query to abend neo4u DB2 5 Mon Apr 23, 2018 1:36 pm
No new posts Query to compare 2 values of 1 column... Poha Eater DB2 13 Fri Mar 09, 2018 10:45 am
No new posts How to replace the below query? pkmurali DB2 12 Tue Feb 27, 2018 9:51 pm
No new posts Need Guidance regarding UPDATE query Poha Eater DB2 3 Mon Feb 12, 2018 11:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us