Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the difference btween join and union

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
induajayrose
Warnings : 2

New User


Joined: 25 Jul 2005
Posts: 28
Location: Thrissur

PostPosted: Fri Sep 23, 2005 8:06 am    Post subject: What is the difference btween join and union
Reply with quote

hai friends,
what is the difference btween join and union.if anyone knows the exact definitions and difference pls give me reply
thanks in advance,
indu
Back to top
View user's profile Send private message

nitin4.a

New User


Joined: 16 Aug 2005
Posts: 26

PostPosted: Fri Sep 23, 2005 11:41 am    Post subject: Re: join and union
Reply with quote

hello

UNOIN: this combines two or more rows and produce the result table structure that have identical structure

JOIN: This combines two or more coloumns and produce the result table structure that can be different from the base tables


regds
nitin
Back to top
View user's profile Send private message
ANIKET

New User


Joined: 28 Apr 2005
Posts: 11
Location: PUNE

PostPosted: Fri Sep 23, 2005 2:56 pm    Post subject: Re: join and union
Reply with quote

hi thr,


in join you can combine number of columns from one table with number of columns from other table. whereas in union we can combine rows from two or more than two table. but for union number of column selected from first table should always equal to that of from another table.

Cheers

:takerest:

Aniket


function can't coffee without in the morning...
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Sep 29, 2005 6:46 pm    Post subject: Re: join and union
Reply with quote

Hi


Join - Combining more than one table with respect to no of columns
Union - Merging more than one table with respect to no of rows.

In Union , the no of cols selected in the first table shld be equal to the no of cols selected in the second table.

In join, we can select any no of cols in the tables.

In Union, both tables column data types should be equal.


Corrections are welcome...

Karthi G.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts How can we have the varying lenth of ... Gunapala CN DFSORT/ICETOOL 6 Fri Oct 14, 2016 7:31 pm
No new posts Join key - Populate Zeros when Unpair... rexx77 DFSORT/ICETOOL 6 Thu May 12, 2016 12:22 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us