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
How to create a button in selection screen ?
How do you process errors in session method ? : abap bdc
can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?
What is the maximum number of structures that can be included in a table or structure
On which event we can validate the input fields in module programs?
How to combine multiple order in one Delivery ( Step by Step)?
What is the t-code for transaction recorder? : abap bdc
How can we send data to external programs?
How did you test the form you developed? How did you taken print?
What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?
write a program for creation of customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA'.
What are the different window types in sapscript?
function modules are also external subroutines. State true or false. : abap modularization
how to update the filed value in SAP in ZAWSYS and create time and date? please tell me the answer
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc