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

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

What is the difference between function and stored procedure in sql server?

0 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

How do I view a procedure in sql server?

0 Answers  

---

what are file groups?

3 Answers   Evalueserve,

---

What are some examples of schemas?

0 Answers  

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

What is in place upgrade in sql server?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

Explain the categories of stored procedure?

0 Answers  

---