Explanatory Question

What is a join?

👁 483 Views

📘 Detailed Answer

🕒 Easy to Read

Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

This is a keyword used to query data from more tables based on the relationship between the fields of the tables. Keys play a major role when JOINs are used.

In SQL server, there are different types of JOINS.
1. CROSS JOIN
2. INNER JOIN
3. OUTER JOIN

Outer Joins are again divided into 3 types
1. Left Join or Left Outer Join
2. Right Join or Right Outer Join
3. Full Join or Full Outer Join

How to use this answer better

First read the answer fully, then try to explain it in your own words. After that, open a few related questions and compare the concepts. This method helps you remember the topic for a longer time and improves exam preparation.