Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and de

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 ---

Question Posted / achoudhr

1 Answers
7746 Views
Principal Finance, PT Metalogix Infolink Persada, I also Faced
E-Mail Answers

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. ..

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

Post New Answer

More Data Warehouse General Interview Questions

How Materialized Views are linked with Oracle DataWare house?

1 Answers Kirloskar,

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

0 Answers

5.Explain ODS ?

3 Answers HCL,

Explain hybrid slowly changing dimension?

0 Answers

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

0 Answers

What is Bulk Insert?

3 Answers

Explain piconet?

0 Answers

Explain what are conformed dimensions?

0 Answers

Explain functional dependency?

0 Answers

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

0 Answers

Explain what is the extension of file to save template?

0 Answers

Explain what is power center repository?

0 Answers

For more Data Warehouse General Interview Questions Click Here