Sweta Kumari is teaching live on Unacademy Plus
educator WELCOME unacademy LEARNERS INDIA'S LARGEST LEARNING PLATFORM unacadem)y
COMPUTER ABOUT ME ENGINEER EDUCATOR@ Sweta Kumari UNACADEMY CONTENT WRITER DOUBT RESOLVER HOME TUTOR QUORA WRITER GOOD ADVISOR Sweta Kumari Learning is Earning The more you learn, The more you Earn. FOLLOW ME FOLLhttps//unacademy.com/user/hellosonuo1
GATE (CS/IT) - DBMS SQL JOINS TABLE 1 TABLE 2
TARGET AUDIENCE GATE (CS/IT)
SQL JOINS COMBINE 2 OR MORE TABLES 1 TABLE 1 TABLE 2
TYPES OF JOINS 1.INNER JOIN 2. CROSS JOIN 3.LEFT OUTER JOIN 4. RIGHT OUTER JOIN 5. FULL OUTER JOIN
In the process of Joining, rows of both tables are combined in a single table.
TABLE TABLE 2 NEW TABLE
Why SQL JOIN is used? o If you want to access more than one table through a select o If you want to combine two or more table then SQL JOIN statement o It combines rows of that tables in one table and one can retrieve o The joining of two or more tables is based on common field o SQL INNER JOIN also known as simple join is the most common type statement. is used the information by a SELECT statement. between them. of join.