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

When you prefer lsmw?

763


What is the bapi?

814


What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr

886


What is asynchronous and synchronous update?

755


how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran

2248






What is difference between check table and value table ?

816


What are the two different ways of building a match code object?

766


What are the differences between interactive and drill down reports?

753


What are the basic components of dialog program?

897


What are the events used in abap in the order of execution?

741


What is dialog module?

789


What two statements would be used to exchange data between programs using abap memory?

699


How will you find manager of an employee

1056


Name the abap/4 modularization techniques?

824


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

805