Explain SQL join with where clause using an example?

Question

Can anyone explain SQL join with where clause using an example?

Answer 1

For example, you have Students table and Marks tables like this:

Students Table

Marks Table

 

Where clause is used to filter the result-set. You can join these two tables on s_id (student id) columns to find the Student Names who scored more than 90 and their scores by using this query:

SELECT s_name, score

FROM Student S

INNER JOIN Marks M on

S.s_id = M.s_id

WHERE score > 90

 

The above query gives the following result:

 

I recommend enrolling in this SQL Training course by Intellipaat to learn writing complex SQL queries.