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 ---
Answer Posted / 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 |
Post New Answer View All Answers
What is the metadata extension?
What are loops in Datawarehousing?
What are the various methods of getting incremental records or delta records from the source systems?
Where the applications and where ware house management system is used?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what is the extension of file to save template?
Explain can report net connect multiple datasource at a time in report creation time?
What are the different types of fact tables used in data warehousing?
How can you communicate with web server (apache or iis) from coldfusion?
explain about dirty dimension?
How to pivot row data using informatica?
What are the difference between snow flake and star schema?
How can you import tables from a database?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Explain the data types present in bo n wht happens if we implement view in the designer n report?