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 are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

What do you understand by replication in sql server?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

What is t-sql script to take database offline – take database online.

0 Answers  

---

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

What is the maximum row of a size?

0 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

What is an index in a database?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---