Join 3 tables (table1, table2 & table3) in a single query. Inner join sh

Join 3 tables (table1, table2 & table3) in a single query.

Inner join should be applied for table1 & table 2 and left
outer join for table1 & table3 where table2.dept is ABC

Question Posted / madkar84-mails

2 Answers
7058 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for ..

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'

Is This Answer Correct ?

11 Yes

0 No

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for ..

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

Is This Answer Correct ?

6 Yes

0 No

Post New Answer