select * from table1 t1 inner join table2 t2 on t1.key = t2.key left o

Join 3 tables (table1, table2 & table3) in a single query.

Inner join should be applied for table1 & table 2 and left
outer join for table1 & table3 where table2.dept is ABC

Question Posted / dhanasekaran

2 Answers
8063 Views
I also Faced
E-Mail Answers

Answer Posted / dhanasekaran

select *
from table1 t1
inner join table2 t2 on t1.key = t2.key
left outer join table3 t3 on t1.key = t3.key
where t2.dept ='ABC'

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

State the difference between union and union all?

985

Where do we use trace frag?

1062

Do you know what is blocking?

994

What do you understand by SQL*Net?

1083

What is a mixed extent?

1078

How can a user-defined datatype be created?

1036

Explain the different types of joins?

1044

What is normalization and denormalization in sql server?

1063

What are different types of raid levels?

1235

What is the difference between resultset and resultsetmetadata?

1030

Do you know what is sql injection?

1041

What are a scheduled jobs?

990

What is stored in the mssqlsystemresource database? : sql server database administration

1081

How to check parameter value in stored procedure sql server?

1027

What is reportserver and reportservertempdb ?

160