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 is modularization and its benefits?

1070


What is the process to enhance the Infotype

3455


Explain what is the step-by-step process to create a table in data dictionary?

1186


What is elementary search help? : sap abap data dictionary

1038


What happens if a function module runs in an update task?

1094


What is at exit-command:?

1039


What is a projection view? : abap data dictionary

1123


Explain about sap fico testing and the tools used? : abap bdc

1140


what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me

2075


Can you set up background processing using call transaction?

1064


What is the use of 'for all entries'?

1117


What is database utility? : abap data dictionary

1137


How to analysis Background Job for performance Issue?

1273


Why we are using Macros instead of Function Modules

2188


What is the relationship existing between the various data elements? : abap data dictionary

1074