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
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr
How to create user interfaces for lists?
what is difference between (internal table types)standard table and sorted table in sap abap....
Explain what is the difference between sy-tabix and sy-index? Where it is used?
Difference between stand alone CRM and back-end CRM
How can we set the table spaces and extent sizes? : abap data dictionary
What is sequence number
What are the advantages and disadvantages of using views in abap programming ?
how to update the filed value in SAP in ZAWSYS and create time and date? please tell me the answer
What is an “on request field” statement?
What is asynchronous and synchronous update?
Explain the data types of internal tables?
What is “call mode”?
What is logo in sap script?