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 do I start sql server?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

what is a deadlock? : Sql server database administration

0 Answers  

---

How to create a stored procedure with a statement block in ms sql server?

0 Answers  

---

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

What is query processing?

0 Answers  

---

How to test odbc dsn connection settings?

0 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---

What is change tracking in sql server?

0 Answers  

---

What is a stored procedure?

3 Answers  

---