What does the following query do?
Select name, ID, branch
from student, department
where student. branch = department.branch;

Question

What does the following query do? 
 Select name, ID, branch 
 from student, department 
 where student. branch = department.branch;

Answer

It gives all values of name, ID, and branch from both the relations only if all those attributes are present in both

Answer

It gives the values of name, ID, and branch from their respective relations, where the values in the branch attribute are the same

Answer

It gives the values of name, ID, and branch from their respective relations, where all the values match with each other

Answer

It gives all values of name, ID, and branch from their respective relations

Crowdly