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

Why do we use abstract class

1021


Can i Have Some Examples on Enhancements.

1969


Explain what is step-loop? Explain all the steps?

704


What are the domains and data element?

558


Explain what is the significance of hide?

522






How can one distinguish between different kinds of parameters? : abap modularization

588


How to find the return code of an stmt in abap programs?

623


What are Tickets in Realtime ?

1671


What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr

594


Define abap/4 layer? : abap data dictionary

597


State the differences between database view & projection view? : abap data dictionary

599


Where the payroll results are stored

1806


Create any functions? How to go about it?

563


Explain the Inportance of pa30? : abap hr

745


Why do we use events and actions in web dynpro?

588