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 are the difference between tables and structures?
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
What are standard layouts sets in the sap script?
Explain the uses of the simple maintenance interface? : sap abap hr
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
What is meant by slab? How is indian slab and us slab? : sap abap hr
What are the uses of interactive reporting?
Can we create a gui status in a program from the object browser?
When value table becomes check table?
What is meant by payscale structure? How did you configure pay scale structure? : sap abap hr
WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.
Explain the difference between function group and function module?
What is Group by in Select statement?
In the `select' statement what is group by ?
What are the steps to be followed to set lockobjects? : sap abap data dictionary