 ZAAQB -      SQL ,     .

  se16n ,       JOIN 
  Alv Robot,    ,          
  Yes4SQL,              ,    ,        .
  SAPQuery,                      .

 SE16        ,          1 
    JOINs 
 ,   ,     ,    
     JOIN

   ,     ,    ,             .


  ,         ,
    
    PF 
       .

CTRL+C, CTRL+V, ENJOY 


 

   5  :

1) Tables

       ,  Alias    Joina    
           .
            .

2) Select

  ,    ZMAIN     ,      .

3) Join  

  Join ,     ,         .
 Join , type , left     Join,  right  , 

4)  join condition 

  joina,    ,       Joina.  Left field    ,   ,
         Joina.

5) Where

      

:      ,    ,    .
:     
: alias  ,         
:   min, max, count, average, sum,       ,    .
 :  .
 :  .
Criteria for : Groups    Having, Values   Where.
NO_check:    (   )
or or or or:    ,       ,   .

     enter,      enter.

    ,
  --      .
save     *         2    ,            .
1     ,     .
           .
List    *         2    ,            .

run query :         .
show code:       .
join wizard:           ,    

       ,       ,          ,
     (   ),       or.

*          .