how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 32526 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 advantages and disadvantages of ABAP query tool?
What does the extract statement do in extract datasets?
In BDC, data transfer is done success in foreground mode but if we done the same in background mode it shows errors. What is the reason?
What is the maximum number of match code id's that can be defined for one match code object ?
How can we send data to external programs?
WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
Can matchcode object contain ids with different update types? : abap data dictionary
can anyone please tell me, in orient paper mill project which fields exits for creating report.
What is a bsp application? : sap abap hr
When, how and how would you control changes to standard SAP objects.
How do you process errors in session method ? : abap bdc
What is the difference between native sql & open sql? : abap data dictionary
What is the difference between synchronous and asynchronous update? : abap bdc
what are the two methods of modifying sap standard tables ?
What is the use of the statement leave to list-processing?
