Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

How to grant a permission in ms sql server using "grant execute" statements?

1065


Define right outer join in sql server joins?

1022


What is merge statement?

1064


Indexes are updated automatically is the full-text index also updated automatically?

1001


Explain external key management in sql server 2008

869


What is the use of custom fields in report?

982


What are the types of processing and explain each? : sql server analysis services, ssas

1133


How to find the list of fixed hard drive and free space on server?

1159


What happens when the SQL Azure database reaches Max Size?

111


What are the methods used to protect against sql injection attack?

1044


Explain how to integrate the ssrs reports in application?

992


Would you store your query in a ssrs report or a database server? State the reason why?

152


What is used to replicate sessions between instances in coldfusion clusters?

1052


What is sql injection? How to protect against sql injection attack?

978


Explain isolation levels that sql server supports?

1023