Retrieve a list of values from a lookup table using db_select
Add more fields to your query from the other tables that you have joined to:

$query-&gt;fields('js');
$query-&gt;fields('s');


Use hook_menu() to create your page if you want a custom one, then render it in PHP (I'm guessing at your result variable):

&lt;table&gt;
  &lt;thead&gt;
    &lt;tr&gt;
       ....
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;th&gt;&lt;?php&gt;$result['job_number']&lt;?&gt;&lt;/th&gt;
      .....
 &lt;/table&gt;