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

Explain the Inportance of pa40? : abap hr

579


MY DOMAIN IS SAP-ABAP COMPARE TO WEBDYNPRO AND CRM-TECHNICAL WHICH IS BEST?

2445


How will you find manager of an employee

859


What is repository info. Systems? : abap data dictionary

586


Can we include customizing include or an append structure with pooled or cluster tables? : abap data dictionary

772






What is the difference between a substructure and an append structure? : abap data dictionary

653


How do you find if a logical database exists for your program requrements?

605


what is diff between idocs,bdc,rfc and bapi. give real time answer

17734


What is pretty printer?

601


What are the differences between domain and data element?

576


What are the advantages/ dis-advantages of logical databases?

548


How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization

605


Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?

1978


What are the types of windows in sap script?

609


What are the steps to be followed to set lockobjects? : sap abap data dictionary

627