|
|
| Author |
Message |
ajaychandra
New User
Joined: 31 Mar 2005
Posts: 16
Location: Bangalore
|
|
|
|
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 |
|
 |
References
|
 Posted: Tue Apr 12, 2005 3:39 pm Post subject: Re: Diff btn Join and View |
|
|
|
|
Sumathi.bonagiri
New User
Joined: 06 Jun 2005
Posts: 3
Location: Bangalore
|
|
|
|
| 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 |
|
|
|
|
