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 modularization and its benefits?
What is the process to enhance the Infotype
Explain what is the step-by-step process to create a table in data dictionary?
What is elementary search help? : sap abap data dictionary
What happens if a function module runs in an update task?
What is at exit-command:?
What is a projection view? : abap data dictionary
Explain about sap fico testing and the tools used? : abap bdc
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
Can you set up background processing using call transaction?
What is the use of 'for all entries'?
What is database utility? : abap data dictionary
How to analysis Background Job for performance Issue?
Why we are using Macros instead of Function Modules
What is the relationship existing between the various data elements? : abap data dictionary