...projpos.po_date,
projpos.po_amt,
projpos.po_notes,
projhours.hrsID,
projhours.project_no,
projhours.empid,
projhours.weekending,
(projhours.hours * (SELECT emp_rate FROM emprates WHERE empid = projhours.empid)) AS "hourstot",
(SELECT emp_dept FROM emprates WHERE empid = projhours.empid) AS...