You can create a View table and use only one select statement.

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

Question Posted / pratima

Answer Posted / pratima

You can create a View table and use only one select
statement.

Is This Answer Correct ?

16 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the basic functions of database utility? : abap data dictionary

591

Differentiate screen painter from menu painter.

559

Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc

641

Differentiate database index and match code.

590

What is logo in sap script?

560

What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?

1817

Does sap handle multiple languages?

552

What are the two ways for restricting the value range for a domain? : sap abap data dictionary

714

What are the functional areas, user groups? How does abap query work in relation to these?

587

Can we use on change of between select and endselect?

565

What are the different software packets available in the market? : sap abap hr

564

Explain what is a logical database?

595

Difference between stand alone CRM and back-end CRM

3814

Can we create a gui status in a program from the object browser?

574

How to call transaction in session method without recording?

1541