ANSI JOINS OR SQL/92 JOINS :-
Example :- Select e.ename, d.dname from emp e inner join dept d on e.deptno=d.deptno
Joining 3 tables :-
Example :- Select e.ename , d.dname, x.expr from emp e inner join dept d on e.deptno=d.deptno Inner join Emp_expr x On x.empno=e.empno.