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 match code? : sap abap hr

1213


What are the components of sapscript?

1075


When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?

1040


What are the different types of mode (run code) in call transaction method?

1168


What are the various events associated with screen programming?

1234


Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?

1067


What is the max no of match code id’s that can be defined for one match code object?

1174


What is the difference between refresh and free statements?

1174


Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc

1245


What is going life actually? What is the role of a functional consultant in it? : sap abap hr

1034


In delivery processing which step comes first picking, packing, posting goods issue ?

2090


What are the difference between tables and structures?

1206


what is the t-code to link technical and functional operation?

2417


Why we are using Macros instead of Function Modules

2133


Explain the client concept of sap.

1028