what are Joins? How many types are there?

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

Question Posted / naren

8 Answers
25569 Views
Keane India Ltd, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are Joins? How many types are there?..

Answer / sudhakar1207

Joins are used to extract data from more than one DB table
which are logically related to each other.
So in order to join DB Tables they should have a common
field or attribute.
In ABAP, We have two types of Joins.
1) Inner Joins
2) Outer Joins ( Left Outer and Right Outer)

Inner Joins retrieve the records which matched with join
condition only.
While outer joins Retrieve the records which are matched
with Join Condition and Remaining records from the Parent Table.

Is This Answer Correct ?

18 Yes

4 No

what are Joins? How many types are there?..

Answer / 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

what are Joins? How many types are there?..

Answer / me

I dont know

Is This Answer Correct ?

9 Yes

3 No

what are Joins? How many types are there?..

Answer / arun prasad

IF WE WANT TO GET THE DATA FROM SOME TABLES WHICH HAS SOME
RELATIONS BETWEEN THOSE THEN WE USE JOINS TO GET THE DATA
BY USING THOSE PRIMARY KEYS.

THERE ARE 2 TYPES OF JOINS, INNER AND OUTER JOINS.

INNER IS USED TO GET THE DATA WHERE THE TABLES ARE IN SAME
DATABASE AND OUTER JOIN IF THEY ARE IN OTHER.

Is This Answer Correct ?

11 Yes

8 No

what are Joins? How many types are there?..

Answer / anu

joins are 2 types.

1.inner join:
inner join is same as join.
2.outer join
i.left outer join
ii.right outer join

Is This Answer Correct ?

3 Yes

0 No

what are Joins? How many types are there?..

Answer / yaswant chauhan

join is the fetch the data from more than one table

it is three types

1- inner join
2- outer join
3- cross join

Is This Answer Correct ?

5 Yes

3 No

what are Joins? How many types are there?..

Answer / sarvesh

Joins are two types:
1- Inner join : Normal join
2- Outer join (Left and Right)

Is This Answer Correct ?

2 Yes

0 No

what are Joins? How many types are there?..

Answer / sunil panghal

Joins are three type in sap abap

1 inner join

2 for all entries

3 subqueries

Is This Answer Correct ?

1 Yes

0 No

Post New Answer