SQL for tracking down Jobs & Virtual Resource

[Todd Clayton]

I’d like to simply select all jobs, and display the jobname and the resources assigned to it. Just jobmst_name  and resmst_name … Any help for someone useless with SQL? :)

[Robert Gardner]

Hey Todd

The resjob table joins the resources to the jobs.  The below query should get you started.

  select jm.jobmst_name,jm.jobmst_id, rj.resjob_id, rm.resmst_name from jobmst jm
  join resjob rj
  on jm.jobmst_id=rj.jobmst_id
  join resmst rm
  on rj.resmst_id=rm.resmst_id

Bob