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

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

975

Explain what are the authentication modes in sql server?

966

How do I setup a sql server database?

1024

What are the database objects? : SQL Server Architecture

1004

what is a mixed extent? : Sql server administration

1048

Explain the working of sql privileges?

1053

List the data types available in mssql?

978

How will you optimize a stored procedure optimization?

978

What are database states in ms sql server?

1135

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

952

Define Wed Edition in SQL Azure?

100

Does hive support indexing?

922

Explain time data type in sal server 2008?

883

What are exact numeric data types in ms sql server?

1021

How many types of built in functions are there in sql server 2012?

891