Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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 personnel administration related infotypes? : abap hr

1013


What is an “on input filed” statements?

1129


Explain the difference between get and get late?

1035


What are different abap/4 editors?

1046


What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary

1829


Write the bdc table structure? : abap bdc

1000


Mention some important events in abap programming.

1006


What data is contained? : abap data dictionary

1075


What are conversion & interface programs in sap?

1093


What are the disadvantages of abap query tool?

1166


What are types of select statements?

1010


How would you define the exponents for a type ‘f’ field?

1014


In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?

2291


What are the different types of the sap abap data dictionary objects?

995


Why are insert and append statement used in sap abap?

1126