What are the joins,types of joins and thier functions?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mehul.v.thakkar@gmail.com
There are basically three types of joins in SAS,
1. Inner Join
2. Left Join
3. Right Join
Inner Join gives the records which are present in both the
datasets.
Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.
Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / kush
Joins are used to join the datasets horizontally.
There are 2 types of joins: inner and outer joins.Outer joins includes left,right and full join.
Inner Join gives the matching records which are present in both the datasets.
Left join gives all the records that are present in left
dataset and matching records in right dataset.
Right join gives all the records in the right dataset and matching records in left datasets
full join gives all matching and non matching records found in both the datasets.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shwetha
1.simple join:-to report matching data from various tables
2.inner join:- to report data.Conditional clause implemented
by on clause.For inner & outer join.
3.outer join:- left join:-to report data from the left side
table & matching data from right side table,right
join:-report overall data from right side& matching data
from the left side table,full join:- report overall data
from both tables & matching.
union join:- adding & combining.
self join:-the table join with same table
natural join:- report matching data from the variable tables
without using conditions.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / saifudheen
inner join...outer join...its used in open sql statements
to retrieve data from database..
Is This Answer Correct ? | 5 Yes | 5 No |
There are basically three types of joins,
1. Inner Join
2. Left Join
3. Right Join
Inner Join gives the records which are present in both the
datasets.
Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.
Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.
Is This Answer Correct ? | 6 Yes | 7 No |
Answer / rus
There are three types of joins:
1. Cartesian Join
2. Inner Join
3. Outer Join
Cartesian Join gives the records for all the combinations
of both the datasets
Inner Join gives only the matching records from both the
datasets
outer join is of three types:
Left Join
Right Join
Self Join
Left Join gives both matched and unmatched records from the
left table/dataset
Right join gives both matched and unmatched records from
the right table/dataset
self join gives matching or unmatched records from the same
table based on the condition
Is This Answer Correct ? | 0 Yes | 2 No |
what is data integration? : Sas-di
What is the purpose of the trailing and How would you use them?
how are numeric and character missing values represented internally? : Sas programming
how many data types in sas? : Sas-administrator
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
what type of graphs we will create(for 2+years candidates)?
what is portability of sas programmes?
Describe the function and untility of the most difficult SAS macro that you have written.
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
what are input dataset and output dataset options? : Sas programming
Tell me more about the parameters in macro? : sas-macro
What are TEAEs
2 Answers Accenture, Quintiles,