title: Progress - Join Tables
body: <p>I'm adding some validation checks before I make records to my database and I need to fulfil the following condition:</p>
  
  <blockquote>
    <p>Find fieldinfo where fieldinfo.fieldno = 5052
    Find codetable where codetable.tableno = fieldinfo.tableno and codetable.code = tt-employee.costcode</p>
  </blockquote>
  
  <p>tt-employee is a temp table , the rest are directly from the db</p>
  
  <p>Since I am new to progress I'm a bit confused - should use a join for that and if so any idea how to do it? Thank you!</p>