title: how to use for each loop in Progress?
body: <p>Basically i'm trying to do a simple join. I'm a beginner in progress and even if i'm reading always the same things... my problem still unresolved ! :'(
  I'm using unixodbc to communicate with my base and this is working like a charm when i'm using simple command like : SELECT * from PUB."Art"</p>
  
  <p>I understood I have to do something who looks like that to join 2 tables : </p>
  
  <pre><code>FOR EACH PUB."Art" WHERE (PUB."Art".IdArt = 16969) ,
      EACH PUB."ArtDet" WHERE (PUB."ArtDet".IdArt = PUB."Art".IdArt)
  END
  </code></pre>
  
  <p>But this only return me [ISQL]ERROR: Could not SQLPrepare</p>
  
  <p>I then try to simplify the thing with : </p>
  
  <pre><code>for each PUB."Art": display PUB."Art".IdArt end.
  </code></pre>
  
  <p>I try to put colon (or not) after the for each loop, using point / comma etc... but I never use the right syntax apparently... or I'm missing a thing to execute this command !</p>
  
  <p>Is anyone can advice me ? 
  Thx a lot !</p>