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

Can you assign a matchcode object to a parameter? If so how?

995

What are number ranges?

1009

What is an update task? : abap modularization

1034

Hi my dear friends,Please give the answers for the following link http://www.saptechnical.com/InterviewQ/interviewQ.htm

2113

How many types of tables exist and what are they in data dictionary?

1109

In sap scripts, how will you link form with the event driven?

948

What are pooled tables?

1008

how do you call third selection screen ?

2080

On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?

971

What is For-period and In-period

2165

What is the major difference between pool tables and transparent tables?

1039

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

1136

To how many tables can an append structure be assigned. : abap data dictionary

1047

What are spa/gpa parameters (sap memory)?

1198

What is the use of table control in bdc is it same in module pool table control? : abap bdc

1150