Give the syntax of Inner,outer Join?"
- 7 Answers
- 31074 Views
- Genpact, HCL, Satyam, I also Faced
- E-Mail Answers
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
Fallback class
Which bdc you prefer? : abap bdc
How to call other programs?
Explain sap abap 3-tier architecture?
What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr
Setting up a BDC program where you find information from?
How can we send data to external programs?
Difference between sy-tabix and sy-index? Where it is used?
Did you create help views?
What is the sap abap?
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
In which particular scenario we use sorted table and which particular scenario we use standard table?
Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?
A field-groups statement or an insert statement reverses storage space and transfers values. State true or false. : abap modularization
How to select valid lines for secondary list?
