select 
	co.co_num,
	co.cust_num, 
	co_line,
	coitem.ref_num,
	coitem.ref_line_suf,
	name, 
	due_date,
	item.item,
	drawing_nbr,
	qty_ordered,
	uf_shippingtolerance,
	qty_shipped,
	coitem.stat 
from 
	co, custaddr, coitem, item
where 
	co.cust_num = custaddr.cust_num and 
	co.cust_seq = custaddr.cust_seq and
	co.co_num = coitem.co_num and
	coitem.item = item.item and
    due_date >= @startdate and due_date <= @enddate and	 
	coitem.stat not in('F','C') and coitem.ref_type = 'J'

select 
	job.job,
	job.suffix,
	job.ord_num,
	job.ord_line,
	jobroute.oper_num,
	wc.description as wc,
	jobmatl.item,
	jobroute.qty_received,
	jobroute.qty_complete,
	jobroute.qty_scrapped,
	jobroute.qty_moved,
	start_date,
	end_date

From
	job,jrt_sch, jobroute, jobmatl, wc
Where
	job.job = jrt_sch.job and
	job.suffix = jrt_sch.suffix and
	job.job = jobroute.job and
	job.suffix = jobroute.suffix and
	job.job = jobmatl.job and
	job.suffix = jobmatl.suffix and
	jrt_sch.oper_num = jobmatl.oper_num and
	jrt_sch.oper_num = jobroute.oper_num and
	jobroute.wc = wc.wc
	
order by job.job asc, job.suffix desc, jobroute.oper_num asc