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

Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary

1067


What are pooled tables?

990


What is buffering allowed but switched off?

1277


What is the t-code to display batch input sessions? : abap bdc

1114


While sorting field groups we cannot use more than one key field. State true or false. : abap modularization

985


How to create any functions?

972


What is partner selection?

1020


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

938


What happens Update command is used without where clause ?

1119


What is an abap dictionary? : abap data dictionary

1005


Can we reuse a userexit?

1430


List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr

879


Where do you code the hide statement?

934


What is the length of function code at user-command?

1246


How to load data from ms excel sheet to sap by using bdc method ? : abap bdc

1218