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

Define a cross join?

0 Answers  

---

Are resultset updatable?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

How do I find the port number for sql server?

0 Answers  

---

What are group functions in query statements in ms sql server?

0 Answers  

---

What is history table in sql server?

0 Answers  

---

What is instead of trigger sql server?

0 Answers  

---

What does ss stand for sexually?

0 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

What is use of dbcc commands?

0 Answers  

---