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 personnel administration related infotypes? : abap hr
What is an “on input filed” statements?
Explain the difference between get and get late?
What are different abap/4 editors?
What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary
Write the bdc table structure? : abap bdc
Mention some important events in abap programming.
What data is contained? : abap data dictionary
What are conversion & interface programs in sap?
What are the disadvantages of abap query tool?
What are types of select statements?
How would you define the exponents for a type ‘f’ field?
In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?
What are the different types of the sap abap data dictionary objects?
Why are insert and append statement used in sap abap?