how can i fetch the records of 3 tables with a single select
query,without using join.
Answer Posted / subhasis
using nested select statement we can fectch the data from 3
table.
like
select f1 f2 f3 from table1 into table wa_t1
slect l1 l2 l3 from table2 into table wa_t2
select e1 e2 e3 from table3 into table wa_t2
endselect.
endselect.
endselect.
If I was wrong pls let me inform
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
What is match code? : sap abap hr
What are the components of sapscript?
When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?
What are the different types of mode (run code) in call transaction method?
What are the various events associated with screen programming?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
What is the max no of match code id’s that can be defined for one match code object?
What is the difference between refresh and free statements?
Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
In delivery processing which step comes first picking, packing, posting goods issue ?
What are the difference between tables and structures?
what is the t-code to link technical and functional operation?
Why we are using Macros instead of Function Modules
Explain the client concept of sap.