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 are Joins? How many types are there?

Answer Posted / rabindra

Joins are 2 types. INNER JOIN, OUTER JOIN.

Inner Join:
In case of inner join there should be an entry in all the
tables use in the view.

Outer Join:
With the use of outer join you can join the tables even
there is no entry in all the tables used in the view.

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures?

1155


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

1043


Why do we use dynamic where conditions?

1362


In what ways we can get the context sensitive f1 help on a field?

1032


What is the use of table maintenance allowed?

1002


What is a view in sap? : abap data dictionary

994


Event handling in oops

1482


What is a data class? : abap data dictionary

1079


What is lock object ? : abap data dictionary

1053


How to display if the value entered contains records or not?

994


Why do we use FOR ALL ENTRIES and what is the pre-requisite

1343


What is the difference between data elements and domains?

1041


What is an “on request field” statement?

1124


What is difference between dialog program and a report?

1111


What is design pattern? Provide example .Why are we using it?

1383