title: Object Oriented approach to retrieve data from two related tables using coldfusion
body: <p>I have a test results database which has the following three tables along with others:</p>
  
  <p>testresults - id, buildid, osid, pass, fail<br>
  build - id, build<br>
  os - id, os  </p>
  
  <p>I generated CFCs using the Adobe CFC generator that comes along with coldfusion builder. Now I have value objects for each table and CRUD methods. I am trying to retrieve all test results records for a particular build and os. Since I want to display the build and os information, I would need information from build and OS tables. Is there a object oriented approach to fetch these results without having to  write queries with joins or create views? </p>