Re: Simple(?) SQL problem
Douglas Wilson wrote:
>
> select job_id, job_desc, job_invoice,
> (select sum(txn_lbr_val)
> from transaction
> where job_id=txn_job_id
> and txn_aid=1000),
> (select sum(txn_lbr_val)
> where job_id=txn_job_id
> and txn_aid=2000)
> from job
> where job_date > "12/1/1996"
and job_id in
(select distinct txn_job_id
from transaction
where txn_aid=1000 or txn_aid=2000)
you might also want to add this last part.
Good Luck,
Doug
*** Disclaimer: These are the opinions of the poster not Amgen Inc.***