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

Explain how data is stored in cluster table?

1200


Explain what are the different functions used in sap script?

1066


Define database layer?

1049


What is transparent table?

1093


Abstract class and interface, multiple inheritance, live example

1352


Can there be more than 1 main window in sap script?

1107


Define dispatcher?

1294


What data is contained in data dictionary? : abap data dictionary

1124


What are field symbols?

1149


Explain buffering concept usage?

1025


Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?

1021


What are the uses of the information in the data dictionary? : abap data dictionary

1221


What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?

1757


What are the parameters used in each function?

1058


What is the difference between a structure and an append structure?

1111