Give the syntax of Inner,outer Join?"
- 7 Answers
- 30991 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
PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..
Hi, I have a requirement for locking the fax field in user master records. As you know user can edit the details using the System>profile>own data (SU3), it is causing some security threat to our model. What i want is users should not be able to change the fax field under communications when they get into su3.I have heard of user Exist functionality but don't know how to implement it. Can you suggest something, it will be greatly appreciated.
What is the difference between a substructure and an append structure?
What is a development class? : abap data dictionary
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
What are the 2 other types of views, which are not allowed in release 3.0?
can anyone please tell me, in orient paper mill project which fields exits for creating report.
What is the difference between free and refresh?
What is meant by authorization? Did you ever work on it? : sap abap hr
What is the tcode to create indexes?
What are null values?
What is the differences between abap and ooabap. In which situation we useooabap?
What are the Control levels in internal tables?
What are the names of the function modules that will be generated upon activation of a lock object?
Which database object is used for storing the system variables? : abap data dictionary
