JOINS IN SQL SERVER скачать в хорошем качестве

JOINS IN SQL SERVER

joins in sql server: Joins play a vital role in retrieving data from 2 or more tables in SQL SERVER. JOIN is the keyword which is used to link 2 or more table and get the required data based on the matching criteria in the joined tables. INNER JOIN is the the most commonly used JOIN in SQL SERVER. INNER JOIN will retrieve the data only if the criteria is satisfied in both the tables. LEFT OUTER JOIN or LEFT JOIN is used to retrieve complete data from left side table and matching data from right side table. RIGHT OUTER JOIN or RIGHT JOIN is used to retrieve matching data from left side table and complete data from right side table. FULL OUTER JOIN or FULL JOIN is used to retrieve complete data from left side table as well as complete data from right side table. That is whether matching record is found or not in the tables all the records from Left and Right side tables will be retrieved. CROSS JOIN or CARTESIAN PRODUCT is a less frequently used or rarely used JOIN in SQL Server. CARTESIAN PRODUCT will match each record from left side table to each record is right side table . That is CROSS JOIN will be a many to many relationship. As the name Suggests SELF JOIN is joining a table with it self. Often a table needs to be self joined to fetch the required results. In such cases SELF JOIN will be used. SELF JOIN is not a keyword or Command, Its just the name of the JOIN.