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 a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
What are pooled tables?
What is buffering allowed but switched off?
What is the t-code to display batch input sessions? : abap bdc
While sorting field groups we cannot use more than one key field. State true or false. : abap modularization
How to create any functions?
What is partner selection?
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
What happens Update command is used without where clause ?
What is an abap dictionary? : abap data dictionary
Can we reuse a userexit?
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
Where do you code the hide statement?
What is the length of function code at user-command?
How to load data from ms excel sheet to sap by using bdc method ? : abap bdc