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 reg query on DYNALLOC feature raghuraman123 SYNCSORT 12 Wed Jan 10, 2018 2:42 pm
No new posts To get Non matching row after compari... vinu78 DB2 7 Fri Jan 05, 2018 5:43 pm
No new posts DB2 catalog tables Pavan kumar chauhan DB2 8 Thu Dec 21, 2017 6:32 pm
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm

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