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

What is save transaction and save point?

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

How do you send email on SQL Server?

0 Answers   MindCracker,

---

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

What is the difference between mysql and sql server?

0 Answers  

---

What are the components of dbms?

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,

---

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

---

How do I shrink an ldf file?

0 Answers  

---

How can we solve concurrency problems?

0 Answers  

---