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 does the ‘suppress dialog’ do?

1404

Structures can contain data only during the runtime of a program (t/f) : abap data dictionary

1246

Explain what is the step-by-step process to create a table in data dictionary?

1077

What is the use of dequeue function module? : sap abap data dictionary

1096

Explain read dataset in sap abap?

1172

The max number of calling modes stacked at one time is?

1057

Can we use on change of between select and endselect?

1014

Define alv programming in abap?

1189

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

1027

How is conversion of data types done between abap/4 & external level?

964

What are clustered tables?

1007

What are spa/gpa parameters (sap memory)?

1192

what is user specific parameter?

2020

What are the difference between call screen and leave screen?

1114

how to track records from data dictionary?

2029