Question

Why we use joins in Database Management System? Define any four joins use in SQL with examples?

Answer 1

The main purpose of the JOIN statement in database is to combine two or more database tables. It is a kind of binary operation. The tables in the database are relates to each other with the help of primary key and foreign key.

SELECT Students.S_ID, Students.S_Name, Course.Course_ID
FROM Student
INNER JOIN Course
ON Students.S_ID=Course.Course_ID;