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.