Join operator allow us to join two or more than two tables to retrieve the desired result set.
Join operator relate the tables on the basis of logical relationship. For joining the tables, at least one column accross the tables must have the same meaning as per business.
We have following type of joins in SQL Server:-
- Inner Join
- Outer Join
- Cross Join
- Self Join
No comments:
Post a Comment