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

Event handling in oops

1130


What are the system fields you have worked with? Explain?

673


How can I make a differentiation between dependent and independent data? : abap hr

563


In BDC, data transfer is done success in foreground mode but if we done the same in background mode it shows errors. What is the reason?

986


How are BAPI different from normal function modules?

1724






Can you print decimals in type n?

570


What is the differences between structure and table in data dictionary in abap?

587


What are the update types possible?

614


​​What is constructor expression in​​ nw​​ abap​​ 7.4?

638


please any one can tell me How to validate the data in Table maintinance generator?how can u validate the table field values if u r entering the data into fields .it shows record is wrong?wher we can done validation in table maitenance generator before getting the data as out ?

1589


Have you set up a back ground job? How to create a background job without a variant ? : abap bdc

599


java script for push button in adobe forms.

1899


What is the structure of bdcmsgcoll? : abap bdc

789


ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul

2177


Can we display a list in a pop-up screen other than full-size stacked list?

698