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
- 7056 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 me what is vldb?
What is the difference between er modeling and dimensional modeling?
How to know the time taken for particular report execution?
What is the capacity of power cube?
5.Explain ODS ?
What are various warehousing tools?
What is index awareness in universe?
Where can one get more info about Data Warehousing?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
if source contain 10records how you identify header and footer
In microstrategy, how can we direct the sql generated to use a specifc table?
Name at least three brands of Database Management Systems
Teradata 
