Why we use joins in Database Management System? Define any four joins use in SQL with examples?
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;
Comments
Leave a comment