Give the syntax of Inner,outer Join?"

Answer Posted / ravi ranjan

syntax of inner join:-
select t1~field1 t1~field2 t2~field3 t3~field4
INTO CORRESPONDING FIELD OF TABLES <INTERNAL TABLE>
FROM TABLE1 AS t1 inner join table2 as t2 on
t1~field1(key field) = t2~field2(key field).

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we specify the next screen number with a variable?

722


Explain the difference between domain and data element?

768


How to handle error in session method? : abap bdc

911


What is table buffer?

745


What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?

793






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

736


What was the requirement of IDoc in your project? How it was working?

1732


Proxy Programming with ABAP - How to develop the Proxy identification through programming

2068


What is new enhancement framework?

1066


Can matchcode object contain ids with different update types? : abap data dictionary

810


What is erp? : sap abap hr

811


Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.

1951


What are the value tables?

750


Can we create a gui status in a program from the object browser?

785


What are the different types of the variable in the sap abap?

763