Assume: T1, T2, T3 are 3 tables. select t1.*, t2.*, t3.* from t1, t2, t3

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

Question Posted / shankar

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

Please Help Members By Posting Answers For Below Questions

What does the insert statement in extract datasets do? : abap modularization

1053

What is a function group? : abap modularization

1074

How do you validate the selection criteria of a report? And how do you display initial

1103

What is a table pool? : abap data dictionary

1065

Which function module would you use to check the user’s authorization to access files before opening a file?

1039

What are the drill-down features provided by abap/4 in interactive lists?

1039

What is narrow casting and wide casting?

1605

How do I find the output type of a table or a program?

983

what is the exact code that shoud be implimented in sap note

2488

Explain the difference between get and get late?

1097

how to modify the standard method as per your requirement

1434

What application areas are you comfortable in?

1364

what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march

2142

Explain the difference between function group and function module?

1134

Can you delete data element, which is being used by table fields. : abap data dictionary

1132