View- it is result set obtained from Select statement.
Join- it is used to join the two related table