Join:

A join is established a connection and creating a relation.


Command:

select student1.name , dept.dept_name , student1.cgpa
from student dept
where student1.dept.id


Inner join:

In this we select that have equal attributes of two tables.


Command:

select student1.name , dept.dept_name , student1.cgpa
from student1 inner join dept
on student1.id=dept.id