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

stock transfer from one plant to another plant ? i want the total description.

2057

What are the prerequisites for creating foreign key relationship?

1167

What are the basic object types? : sap abap hr

1161

What is the difference between abap and hr abap? : abap hr

1150

What is the procedure you followed to upload the data?

1089

what is code to upload cost centers through call trans. and procedure

2636

What are the components of selection table?

1053

What are the abap/4 commands that link to a layout set?

1374

how can you display data say "your name"in sap script without print program or driver program??

2210

What are local objects? : abap data dictionary

1082

What are the differences between se01, se09 and se10?

1011

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

1194

What are pooled tables? : abap data dictionary

1152

What’s value table?

1062

What are the page windows? How many main windows will be there in a page window?

970