Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Diff btn Join and View

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
ajaychandra

New User


Joined: 31 Mar 2005
Posts: 16
Location: Bangalore
PostPosted: Tue Apr 12, 2005 3:39 pm    Post subject: Diff btn Join and View
 Reply with quote
Dear Friends

What is the basic difference between view and a join.

Why i am asking is ..... by using views or joins we can combine columns from one or more tables and can update only if view or join are from one table only, if its more than one it cant be updated in both cases.

then what is the diff btw view and a join....

Ajay Chandra
Back to top
View user's profile Send private message
References
Sumathi.bonagiri

New User


Joined: 06 Jun 2005
Posts: 3
Location: Bangalore
PostPosted: Tue Jun 07, 2005 6:08 pm    Post subject: Re: Diff btn Join and View
 Reply with quote
ajaychandra wrote:
Dear Friends

What is the basic difference between view and a join.

Why i am asking is ..... by using views or joins we can combine columns from one or more tables and can update only if view or join are from one table only, if its more than one it cant be updated in both cases.

then what is the diff btw view and a join....

Ajay Chandra



Hi ajay

The difference b/w join and view is view is a virtual table ,and join is an existing thing.
Access permissions can be set on views in case of joins its not so.
this much i know.
any corrections welcome.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1