Interested to Buy Any Domain ? << Click Here >> for more details...
how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 34162 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 function does data dictionary perform?
What are the aggregate objects in the data dictionary? : abap data dictionary
What is a report?
PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'
How can the standard tables of sap be modified?
What are system fields for secondary lists?
how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?
1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?
Explain buffering
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
What are different types of parameters?
pls if any one have idea ,reply as soon as possible 1.Allied solution group inc. is a genuine company or not ? 2.what is update module. 3.Transaction: scc3 what it is?
What are field symbols?
How many types of tables exists and what are they in data dictionary? : abap data dictionary
What are the differences between session method and call transaction method? : abap bdc
