title: select more fields within one select
body: <p>I manage to do the selection with more selects and a loop. 4 tables ( the last one was just for collecting all the data )</p>
  <p>But now i'm thinking of a way to select all the fields i need with just one select statement. Here is the huge select :)</p>
  <pre><code>  SELECT vbak~vbeln vbak~audat
           tvakt~bezei
           vbap~posnr vbap~matnr vbap~kwmeng vbap~vrkme
           lips~vbeln lips~posnr lips~werks lips~lfimg
           vbfa~vbtyp_n
      FROM vbak JOIN vbap ON vbak~vbeln = vbap~vbeln
                JOIN tvakt ON vbak~auart = tvakt~auart
                LEFT JOIN vbfa ON vbfa~vbelv = vbak~vbeln AND vbfa~posnv = vbap~posnr
                JOIN lips ON vbfa~vbeln = lips~vbeln AND vbfa~posnn = lips~posnr
      INTO TABLE gt_salord
      WHERE tvakt~spras = 'EN' AND
            vbak~vbeln IN s_vbeln AND
            vbak~audat IN s_audat.
  </code></pre>
  <p>The problem is this doesn't work. When i try to activate it throws this error: &quot; Unable to compare with &quot;VBAP~POSNR&quot;. A table can be joined with a maximum of one other table using LEFT OUTER JOIN &quot;
  If i don't use LEFT JOIN and only JOIN it works but i don't get all what i want. I need to get all the SALES ORDERS even if they don't have a DELIVERY ORDER assigned. Is there a way to do that, or do i really have to split my select?</p>