Answer / 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'

Answer / sumit m.

Although the above answer is correct. I am preferring
paranthesis in the answer, something like below:

There are 2 forms of the query for the answer:

SELECT *
FROM (table t1 INNER JOIN table2 t2 ON t1.col = t2.col AND
t2.dept = 'ABC')
LEFT JOIN table t3 ON t1.col = t3.col

OR

SELECT *
FROM (table t1 INNER JOIN (SELECT * FROM table2 WHERE dept
= 'ABC') t2 ON t1.col = t2.col)
LEFT JOIN table t3 ON t1.col = t3.col

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

---

What are the different types of sub-queries?

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---

Explain about service Broker functions?

0 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---