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 / m.kmart

If the creteria is to use "Single" select query, then
create a view on the 3 tables in the question and inturn
write a single select satement.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the function module and a normal abap/4 subroutine?

1177


What is the purpose of sum statement?

988


What are the differences between table and structure in data dictionary?

1093


What are matchcodes?

975


How do you save data in bdc tables? : abap bdc

1084


How to get that a secondary index is attached to a select query?

1352


How to select valid lines for secondary list?

1076


What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary

1010


Explain the sequences of event block?

1012


Explain how to create any functions? How to go about it?

1002


In the MM module for finding out the standard cost what is the view one has to look at?

1036


Where can you find error log for call transaction? : abap bdc

1254


How to creat transactions? : abap data dictionary

1116


Can we set page headers to details lists?

1027


Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3689