nandeesh.keelara

 Profile Answers by nandeesh.keelara 

• Jan 3rd, 2007

 

View- it is result set obtained from Select statement.

Join- it is used to join the two related table

vmshenoy

 Profile Answers by vmshenoy Questions by vmshenoy

• Jan 9th, 2007

 

view  is  a virtual table where data is not stored physically  but give the convenient method to retrieve and manipulate the info as needed.done for SECURITY REASONS. helps make SIMPLE QUERIES.

Join is joining of two tables


 

cc

• Mar 22nd, 2007

 

View:View is a virtual table, which is created by records from two or more tables.
          syntax: create view viewname as select statement.


Join: Joins are used to retrive data from two very distinctive tables.

rajakumar_na

 Profile Answers by rajakumar_na 

• Nov 14th, 2007

 

One more point is
View is a Schema Object
Join is not a schema object

NOTNULL

 Profile Answers by NOTNULL 

• May 18th, 2009

 

View is mainly created to provide security for the data and data definitions.
Mainly used to retrieve the data in a secure manner.
View cannot use space in the physical memory means virtually it will resides.
Join mainly used to join the data from two or more tables.
It is the RDBMS concept I mean not a
DBMS.
Join also resides in the virtual.