Answer to Question #169657 in Databases | SQL | Oracle | MS Access for william

Question #169657

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





1
Expert's answer
2021-03-08T07:15:31-0500

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;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS