Assume: T1, T2, T3 are 3 tables.

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

Let me know if i was wrong.

Hi,

Using For all entries we can fetch the records of 3 tables. 
if I am wrong, let me know.

select max(sal) as sal from
(select max(sal) as sal1 from emp1
union
select max(sal) as sal2 from emp2
union
select max(sal) as sal3 from emp3)
 salary order by sal desc

u can get the max sal from three tables  lets try to do this

select mara~matnr from mara.
select vbrk~arktx from vbrk where arktx = mara~matnr.
select ........
endselect

using nested select statement we can fectch the data from 3 
table.
like 

select f1 f2 f3 from table1 into table  wa_t1
   slect l1 l2 l3 from table2 into table wa_t2
    select e1 e2 e3 from table3 into table wa_t2

   endselect.
  endselect.
endselect.

If I was wrong pls let me inform

You can create a View table and use only one select 
statement.

If the creteria is to use "Single" select query, then 
create a view on the 3 tables in the question and inturn 
write a single select satement.

SORRY I CAN'T SAY BECAUSE I KNOW ONLY
VIEWS (OR)
INTERNAL TABLE (OR)
STRUCTURE
FETCH THE RECORDS OF 3 TABLES WITH A SINGLE SELECT .

records can be fetched from 3 tables using a single select 
statement using the CHAIN OPERATOR in select statement....

select : vbeln posnr matnr from VBAK into table i_abc1
                                   where vbeln = s_vbeln,
         vbeln1 posnr1 matnr1 from VBAk1 into table i_abc2
                                   where posnr2 = s_posnr,
        vbeln2 posnr2 matnr2 from VBAK2 into table i_abc3
                                   where matnr2 = s_matnr2.

..the only difference which makes is the chain operator.

View is correct.

we can use alternative to joins are
1.for all entries
2.views.

REPORT  ZFFFFFFF.
TABLES: mara, makt, vbak.
TYPES: BEGIN OF xitab.
    INCLUDE STRUCTURE vbak.
    TYPES:END OF xitab.

TYPES: BEGIN OF yitab.
    INCLUDE STRUCTURE mara.
    TYPES:END OF yitab.

    TYPES: BEGIN OF zitab.
    INCLUDE STRUCTURE makt.
    TYPES:END OF zitab.

    data:i_abc1 type STANDARD TABLE OF xitab WITH HEADER 
LINE,
          i_abc2 TYPE STANDARD TABLE OF yitab WITH HEADER 
LINE,
          i_abc3 TYPE STANDARD TABLE OF zitab WITH HEADER 
LINE.

select : vbeln  from VBAK into CORRESPONDING FIELDS OF 
TABLE i_abc1
                                   where vbeln 
= '0000004969',
         matnr from mara into CORRESPONDING FIELDS OF TABLE 
i_abc2
                                   where matnr = '102-310',
        maktx  from makt into CORRESPONDING FIELDS OF TABLE 
i_abc3
                                   where maktx = 'Test 
material'.

  WRITE:/ 'Experiment successful'.