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
- 7875 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 |
What is Discrete and Continuous data in Data mining world?
What are the methodologies of data warehousing?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is latest version of power center / power mart?
Explain what are data marts?
How to limit the max no of rows retrieved in the report?
What is difference between Business Objects and Hyperion Essbase? Please help me
What are aggregate fact tables ? why they are needed? give an example
What is the difference between narmal load and bulk load?
What is the difference between connected and unconnected stored procedures?
What is a fact, dimension, measure?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
Teradata 
