I need to generate the report in which there outer join should come between the dimension tables in the SQL?

Suggest me solution without using logical views

Hi, you can practice the following queries to ore abt outer joins. Outer join - method of retreiving selected rows from one table that doesn't match rows with the other table. Ex: consider a & b two tables select eno, ename, a.dno, dname from a,b where a.dno=b.dno; output: eno ename dno dname 100 john 10 accounts 101 michael 20 sales 30 production 40 purchase in outer join 2 types r there: left outer join & right outer join ex: leftouter join select eno, ename, a.dno, dname from a,b where a.dno(+)=b.dno; display all the rows from "table a". Output: eno ename dno dname 100 john 10 accounts 101 michael 20 sales 102 anni 20 sales 103 sonia 105 mann ex: right outer join select eno, ename, a.dno, dname from a,b where a.dno=(+)b.dno; display all the rows from "table b". Output: eno ename dno dname 100 john 10 accounts 101 michael 20 sales 102 anni 20 sales 30 production 40 purchase