View and Join : two different way to join 2 or more 
database table.

Join should be used to join 2 or 3 table small size table ..
performance will reduce in case of join b/w two large 
database table.

View are always better then join in terms of performance....

view contains 5 number of types.
in database view is joins 2 or more tables,
joins also do same work.
join is nothing but a database view.
view is generate the code and gives the result of table.
but our own 'join code' not genrate any programe but we 
write reqired code for it and there is no external code is 
genrated. thatsway join is better than view.
so we used to 'join' for write report programs.