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 the joins,types of joins and thier functions?

Answer Posted / sree

There are two types of joins
1.Inner joins
2.Outer joins
The outer join is of 3 kinds
- Right join
- Left join
- Full join
Inner join have following characteristics
-return only matching rows
allow max of 32 tables to be joined at the same time
Outer joins--can retrive nonmatching as well as matching
rows.
--outer joins are limited to two tables at a time.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are symget and symput? : sas-macro

1244


What is the difference between the proc sql and data step?

1108


Why double trailing @@ is used in input statement?

1151


What do the PUT and INPUT functions do?

1271


What are the default statistics for means procedure?

1171


what are some good sas programming practices for processing very large data sets? : Sas programming

879


Explain proc sort?

1030


what is the use of sas management console? : Sas-di

1036


What is the order of application for output data set options, input data set options and SAS statements?

1506


How do you use the do loop if you don’t know how many times you should execute the do loop?

1215


Have you ever used the SAS Debugger?

1695


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3529


Explain input and put function?

1085


What is the use of %include statement?

996


How does the internal authentication work in sas? : sas-grid-administration

1068