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
Answer Posted / 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 |
Post New Answer View All Answers
Mention the different types of triggers?
What do you mean by stored techniques? How would we use it?
Why use cursor in sql server?
What is the difference between function and stored procedure in sql server?
When would you use it?
write an SQL query to list the employees who joined in the month of January?
What happens on checkpoint?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What do you mean by SQL injection attack?
Mention the different authentication modes in sql server.
Explain the dbcc pintable command when would you use it?
What is data block and how to define data block size?
What are the security related catalog views? : sql server security
what are acid properties? : Sql server database administration