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
7812 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 are the different types of backups avaialabe in sql server 2005?

970

What is an sql server agent?

995

What is the data type of time?

910

Define left outer join in sql server joins?

906

Which are the olap features?

907

What is report snapshot?

142

Why use “in” clause in sql server?

995

why would you call update statistics? : Sql server database administration

1011

what is an index? : Sql server database administration

931

What are sub reports and how to create them?

124

What are the commands used in DCL?

965

What is sub-query in sql server?

1140

what is checksum in sql server.........???

1619

What is the process of indexing?

942

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

909