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
Can we specify the next screen number with a variable?
What are the different types of laws. What are they?
How many types of tables exist and what are they in data dictionary?
What are the prerequisites for creating foreign key relationship?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subarc after perform?
Why grouping of fields is required? What is the max no of modification groups for each field?
What is a help view? : abap data dictionary
What are the pooled and cluster tables?
What is meant by stacked list?
what is difference between set screen and call screen ?
THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM
How is conversion of data types done between abap/4 & external level?
What are the differences between se01, se09 and se10?
What are the different buffering methods?
What are the different types of parameters? : abap modularization