title: Progress ABL: BREAK BY With multiple joins in an OPEN QUERY
body: <p>I'm pretty new to ABL (and I'm French so please excuse my English) so I need your help.
  I'd like to know how to use a BREAK BY in an OPEN QUERY.</p>
  
  <p>Here's what I do:</p>
  
  <pre><code>define query Q-REQ for 
  ENT_RCP_FRN,
  LIG_RCP_FRN,
  CONSO_UNV_MDIM,
  LIG_DOC_TRS,
  ENT_DOC_TRS scrolling.
  
  open query Q-REQ for
   each ENT_RCP_FRN no-lock
     where  ENT_RCP_FRN.STO-c-CodeDes = "DRET", 
   each LIG_RCP_FRN no-lock break by LIG_RCP_FRN.SKU-c-cod
     where LIG_RCP_FRN.SOU-c-Cod = ENT_RCP_FRN.SOU-c-Cod 
     and LIG_RCP_FRN.ERF-c-NumRcpFrn = ENT_RCP_FRN.ERF-c-NumRcpFrn,
   each CONSO_UNV_MDIM no-lock
    where CONSO_UNV_MDIM.UMA-c-Code = "8B6A9/0001354"
    and CUMD-c-LstCleCumConso = LIG_RCP_FRN.SKU-c-cod,
   each LIG_DOC_TRS no-lock LEFT OUTER-JOIN
     where LIG_DOC_TRS.SKU-c-Cod = LIG_RCP_FRN.SKU-c-Cod,
   each ENT_DOC_TRS no-lock left outer-join
     where ENT_DOC_TRS.SOU-c-Cod = LIG_DOC_TRS.SOU-c-Cod
     and ENT_DOC_TRS.EDT-c-NumDocTrs = LIG_DOC_TRS.EDT-c-NumDocTrs
     and ENT_DOC_TRS.TR-c-CodeCatDoc = "BT"
     and ENT_DOC_TRS.STO-c-CodeOri = "DRET"
     and ENT_DOC_TRS.STO-c-CodeDes = "DWHO".
  
  
  repeat :
  
       get next Q-REQ.
       if not available ENT_RCP_FRN then leave.
  
  
  end.
  </code></pre>
  
  <p>I get an error at the following statement:</p>
  
  <pre><code>each LIG_RCP_FRN no-lock break by LIG_RCP_FRN.SKU-c-cod
     where LIG_RCP_FRN.SOU-c-Cod = ENT_RCP_FRN.SOU-c-Cod 
     and LIG_RCP_FRN.ERF-c-NumRcpFrn = ENT_RCP_FRN.ERF-c-NumRcpFrn,
  </code></pre>
  
  <p>Unable to understand after:  "LIG_RCP_FRN.SKU-c-cod" (my error is in French, but it is error 247):</p>
  
  <p>247** L'expression après : "LIG_RCP_FRN.SKU-c-cod" est incompréhensible. (247)</p>
  
  <p>What I'd like to do is to be able to sum a column from the table LIG_RCP_FRN, breaking when the SKU-c-Cod changes.</p>
  
  <p>I tried to delete every statement after this error, but It didn't work neither.</p>
  
  <p>Please ask if you need more information.
  Openedge progress 10.2A</p>
  
  <p>Thank you for your help,
  Corentin</p>
  
  <p>PS: impossible to say "Hi" in a post??</p>