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

Have you set up a back ground job? How to create a background job without a variant ? : abap bdc

593


How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?

567


What are Tickets in Realtime ?

1673


Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?

1596


Can we create an abap program without using y or z?

568






Explain get pernr concept when we use logical data base? : abap hr

747


How can we set the tablespaces and extent sizes ?

567


What is a multiple line field?

588


What is pass by value and what is pass by reference? Which is better?

834


What is personnel sub are

1572


How will you define posting procedures?

904


What are the differences between table and structure in data dictionary?

598


in bdcsome times we get the ok code for "enter" wrongly instead of '/00'.what is the reason.how we can exceed this problem.

1721


How can we upload a text file having delimiters in to legacy system? : abap bdc

612


What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary

513