In real time scenario Main table divided into number of sub tables but while selecting data from multiple tables we to JOIN the tables.
In Sql Server there existed three types of joins which includes
1. INNER JOIN
2. OUTER JOIN
3. CROSS JOIN
Joins
Joins in Sql Server are used to select the data from multiple tables using a single select statement.
In real time scenario Main table divided into number of sub tables but while selecting data from multiple tables we to JOIN the tables.
In Sql Server there existed three types of joins which includes
1. INNER JOIN
2. OUTER JOIN
3. CROSS JOIN
In real time scenario Main table divided into number of sub tables but while selecting data from multiple tables we to JOIN the tables.
In Sql Server there existed three types of joins which includes
1. INNER JOIN
2. OUTER JOIN
3. CROSS JOIN
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment