I am trying to create a derived field that sums multiple other fields from another table. (Total Hours for a Job based on the scheduled hrs fields. Here is my statement and the error I am receiving. Any help would be greatly appreciated.
(SELECT SUM(jsh.sched_hrs)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix)) +
(SELECT SUM(jsh.move_hrs)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix)) +
(SELECT SUM(jsh.queue_hrs)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix)) +
(SELECT SUM(jsh.setup_hrs)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix)) +
(SELECT SUM(jsh.finish_hrs)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix)) +
(SELECT SUM(jsh.offset_hrs)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix)) +
(SELECT SUM(jsh.run_lbr_hrs * job.qty_released)
FROM jrt_sch jsh
WHERE (job.job = jsh.job) and (job.suffix = jsh.suffix))
