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
Explain how many types of tables exist and what are they in data dictionary?
What do you mean by pooled tables in sap abap? Also explain what do you mean by table pool? : abap data dictionary
How to call other programs?
How the transaction that are programmed by the user can be protected?
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
How can we access the correction and transport system? : abap data dictionary
Which bdc you prefer? : abap bdc
What are the user interfaces of interactive lists?
What are matchcodes?
What is the difference between leave transaction and call transaction?
how to read the standard field value in your custom program.
when do you need to create an internal table with header line ? and with out a header line?
What is the use of the raising exception?
Explain different types of locks?