- Sometimes we have to combine the data from so many tables.
- A join combines the data spread across tables.
- A join is performed by the 'where' clause which combines the specified rows of tables.
- A common column provides the join condition.
- The most important and frequently used of the joins is the inner join.
- They are also referred to as EQUIJOIN.
- Inner join retrieve only the 'MATCHED RECORDS'.
- A join that is based on relational operators other than = is called a non-Equi join.
- The outer join extends the result of a simple join.
- An outer join returns all the rows from one table that do not match any row from the other table.
- The symbol + is used to represent the outer join.
- All the records from the left side table and only the matched rows join from the right side table.
- All the records are from the right side table and only the matched rows left side table.
- Self-join is a regular join, but the table is joined with itself.
👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.
📬 Contact Me | LinkedIn | GitHub
📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.