how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 32049 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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 are the requirements a dialog program must fulfill?
hi,i worked mostly in core abap.know iam assigned to XI utility project.can u experts let me know what r the basic things i need to learn to work in XI utility project.i already searched in forum.thanks in advance.
What is pass by value and what is pass by reference? Which is better?
What are the events used for logical database?
What are the different function modules used in sapscript?
What are the different methods of passing data? : abap modularization
What are the system fields? Explain?
How can end-of-selection be used?
What are advantages and disadvantages of logical data base
Why cant we use Normal function module for data transfer?
Explain buffering concept usage?
Does the table can have multiple foreign keys?
What are the different types of luws?
What is native sql?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
