What is a join for?
Student(roll_no, name, dept_id) and Department(dept_id, dept_name).
You want a list of student names next to their department names.
What do you need?
Student(roll_no, name, dept_id) and Department(dept_id, dept_name).
You want a list of student names next to their department names.
What do you need?