SQL revise

INNER JOIN - find pair of rows of tables satisfied to join-predicate. When the join-predicate is satisfied, column values for each matched pair of rows of A and B are combined into a result row.

1.  explicit
2.  implicit

• Explicit

select * from emp inner join dept on (emp.deptno=dept.deptno)

• Impicit

select * from emp, dept where emp.deptno=dept.deptno
The result of both queries is the same.