If the creteria is to use "Single" select query, then create a

how can i fetch the records of 3 tables with a single select
query,without using join.

Question Posted / m.kmart

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

Please Help Members By Posting Answers For Below Questions

What is table pool?

751

What are the steps to be followed to set lockobjects? : sap abap data dictionary

835

Explain the advantages of logical databases?

773

What are the 2 other types of views, which are not allowed in release 3.0?

799

Difference between Insert, Update and Modify?

875

What is abap dictionary or data dictionary? What is the transaction to access abap dictionary? : abap data dictionary

734

What happens if only one of the commands set screen and leave screen is used without using the other?

789

What are two methods of modifying sap standard tables?

761

State the system field for the current date?

798

What is the function of the transport system and workbench organiser? : abap data dictionary

804

What is meant by write lock? : sap abap data dictionary

790

Explain what are the events used for logical database?

685

Name the abap/4 modularization techniques?

824

hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp

3396

How to create a check box/option button in a list?

2661