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...

What is meant by Join? What are the different types of
Joins available? Explain.

Answer Posted / mahesh

joins are used to relate two tables and display the result..

Types of join

1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different functions in sorting an array? : Sql dba

967


How can we store rows in PL/SQL using array?

1158


What are the operators in sql?

969


Is sql a microsoft product?

894


How would you pass hints to the sql processor?

919


What is the difference between inner join and outer join?

928


Why do we use procedures?

910


What is exception? What are the types of exceptions?

1029


What is difference between sql and excel?

1005


What is the difference between inner join and left join?

934


How to read/write files from pl/sql?

990


Are subqueries faster than joins?

947


what are tables and fields? : Sql dba

987


What is a pragma statement?

1200


Is and as keyword in pl sql?

898