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

How to grant a permission in ms sql server using "grant execute" statements?

1065

Define right outer join in sql server joins?

1022

What is merge statement?

1064

Indexes are updated automatically is the full-text index also updated automatically?

1001

Explain external key management in sql server 2008

869

What is the use of custom fields in report?

982

What are the types of processing and explain each? : sql server analysis services, ssas

1133

How to find the list of fixed hard drive and free space on server?

1159

What happens when the SQL Azure database reaches Max Size?

111

What are the methods used to protect against sql injection attack?

1044

Explain how to integrate the ssrs reports in application?

992

Would you store your query in a ssrs report or a database server? State the reason why?

152

What is used to replicate sessions between instances in coldfusion clusters?

1052

What is sql injection? How to protect against sql injection attack?

978

Explain isolation levels that sql server supports?

1023