Interested to Buy Any Domain ? << Click Here >> for more details...
Select * from emp,dept,loc where emp.deptno left outer join
dept.deptno and dept.locno=loc.locno.
No need to consider the syntax but is it possible to have
left outer join and equi join in the same SQL like this ?
can we have right outer join and left outer join in the
same SQL ---
- 1 Answers
- 7818 Views
- Principal Finance, PT Metalogix Infolink Persada, I also Faced
- E-Mail Answers
Answer / mayur
You can very well put Inner / Left Outer / Right Outer join
in the same SQL Query.
| Is This Answer Correct ? | 14 Yes | 0 No |
Explain hybrid slowly changing dimension?
What are the tools available for etl?
How to limit the max no of rows retrieved in the report?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain which are the olap tools available that are supported by oracle?
Tell me what is degree of a relation?
What is cubes?
What is the difference between agglomerative and divisive hierarchical clustering?
What are non-additive facts in detail?
What is many-to-many dimensional model in datawarehousing ?
Explain what does level of granularity of a fact table signify?
which automation tool is used in data warehouse testing?
Teradata 
