Hi i am surya, i have faced this questions plz give me the
answer.
I have requirement like this, i have two internal tbale like
itab and itab1 in itab i have 50 records, in itab1 100
records are there. When execute this question what will be
the output a]50 b]100 c]150? And how to join two internal
tables what is the syntax for that?

Answer Posted / sameer

hiii surya b clear wid the question first..

n buddy mahesh the synatx is wron for inner n outer joins..

syntax:

select tab1~fields
tab2~fields
into table <body>
from <tab1> inner join <tab2>
on <tab1~field1> = <tab2~field1>.

juz for outer join add in place of inner join.

Cheers.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What primary key and foreign key relationship

890


Can we use flow logic control key words in abap/4 and vice-verse?

570


What are the types of subroutines? : abap data dictionary

590


How you attach search help to data element? : sap abap data dictionary

668


What are null values? : abap data dictionary

623






What is a subscreen? How can we use a subscreen?

568


did u done enhancement framework?how u implemented?

5045


Where are you used type casting?

918


What is an rdbms?

587


What are the advantages and disadvantages of ABAP query tool?

581


Why do we use abstract class

1031


How to display or know if the value entered contains records or not?

582


What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr

754


What are th control break events in abap?

612


List some of the many different ways that the sap standard functionality can be changed by a customer?

554