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

Answer Posted / shankar

Assume: T1, T2, T3 are 3 tables.

select t1.*, t2.*, t3.* from t1, t2, t3

Let me know if i was wrong.

Is This Answer Correct ?    10 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an interface? In what scenario we use interface? What is the difference between abstract class and interface?

914


when do you need to create an internal table with header line ? and with out a header line?

1481


Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary

607


What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc

549


What will exactly the hide statement do?

570






What is the difference between upload and ws_upload ? : abap bdc

671


A subroutine can contain nested form and endform blocks. State true or false. : abap modularization

766


What are the different abap editors? What is the used of different editors in abap?

564


Filter badi and multiple used badi? Will the sequence matter of the badi implementation in case of multiple used badi?

1279


What is tcode se16. For what is it used. Explain briefly?

538


What is the client concept in sap?

549


What are the two methods for modifying sap standard tables?

726


What do you mean by transparent tables in sap abap? : abap data dictionary

517


What are the functional areas? User groups?

592


What are the differences between a database index and a match code?

592