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


Please Help Members By Posting Answers For Below Questions

What are the advantages and disadvantages of ABAP query tool?

790


What does the extract statement do in extract datasets?

878


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?

1228


What is the maximum number of match code id's that can be defined for one match code object ?

754


How can we send data to external programs?

926


WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA

2312


Can matchcode object contain ids with different update types? : abap data dictionary

888


can anyone please tell me, in orient paper mill project which fields exits for creating report.

1540


What is a bsp application? : sap abap hr

868


When, how and how would you control changes to standard SAP objects.

1663


How do you process errors in session method ? : abap bdc

851


What is the difference between native sql & open sql? : abap data dictionary

843


What is the difference between synchronous and asynchronous update? : abap bdc

889


what are the two methods of modifying sap standard tables ?

823


What is the use of the statement leave to list-processing?

809