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 the diffrence between inner and outer join

Answer Posted / apoorv sharma

You use INNER JOIN to return all rows from both tables where
there is a match. ie. in the resulting table all the rows
and colums will have values.

In OUTER JOIN the resulting table may have empty colums.
Outer join may be either LEFT or RIGHT

LEFT OUTER JOIN returns all the rows from the first table,
even if there are no matches in the second table.

RIGHT OUTER JOIN returns all the rows from the second table,
even if there are no matches in the first table.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to be followed to set lockobjects? : sap abap data dictionary

1124


What is difference between float and packed data type?

1201


What are the requirements a dialog program must fulfill?

1108


did u done enhancement framework?how u implemented?

5543


Explain the difference between domain and data element?

1032


when run my program in se38 it was showing output, when i take background execution and giving printer details it was shoing out put. but in SP01 when i give the Spool Request Number it was showing not yet processed entire page why it happens i dont know please give me a solution.

2584


What is the length of function code at user-command?

1325


What is a size category?

1138


What is meant by authorization? : sap abap hr

1186


What is the difference between getting and get late?

1032


What is the collect statement?

1151


What is the function of the transport system and workbench organiser? : abap data dictionary

1072


Give examples of transparent table?

1186


List the events in abap/4 language?

1120


IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.

1949