Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7977 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is identity?
How to make remote connection in database?
What is the difference between count () and rowcount ()?
How can you see what type of locks used?
What are the extra roles available in msdb? : sql server security
Which table keeps the locking information?
Explain the truncate command?
What is the use of tempdb? What values does it hold?
What is a mutating table error and how can you get around it?
Define ACID properties in a Database?
What are the basic features of a trigger in ms sql server?
What are alternate keys?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
