>DECLARE @tcEmpno char(9) >SET @tcEmpno = '000000298' >SELECT jobinfo.ljob, COUNT(jobinfo.ljob) AS Weight, jobinfo.costdate, jobinfo.starttime, > CASE WHEN bbjthead.id = '' THEN '(No-ID)' ELSE bbjthead.id END AS ID FROM > ( > > SELECT ljob, costdate, starttime FROM bbjobcst > WHERE ljob <> ' ' AND ljob <> 'None ' AND costdate >= GETDATE() - 15 AND empno = @tcEmpno > --ORDER BY costdate desc, starttime desc > > UNION ALL > > SELECT ljob, costdate, starttime > FROM bbmatdc > WHERE ljob <> ' ' AND ljob <> 'None ' AND > costdate >= GETDATE() - 15 AND empno = @tcEmpno > --ORDER BY costdate desc, starttime desc > > UNION ALL > > SELECT ljob, costdate, starttime > FROM bbrolldc > WHERE ljob <> '' AND ljob <> 'None ' AND costdate >= GETDATE() - 15 AND empno = @tcEmpno > --ORDER BY costdate desc, starttime desc > > )jobinfo > > INNER JOIN BBJTHEAD ON BBJTHEAD.LJOB = jobinfo.ljob >GROUP BY jobinfo.ljob, BBJTHEAD.ID, jobinfo.costdate, jobinfo.starttime >ORDER BY jobinfo.costdate desc, jobinfo.starttime desc>Does anyone have any ideas on how I can accomplish this???