Writing an SQL SELECT statement
There is no need to do the deep abstraction for the Select *. You can simply reference the columns you want and include them in the result...

SELECT JOB_NUM,
       ITEM_NUMBER,
       DATE_COMPLETED,
       QTY_COMPLETED,
       STD_USAGE,
       ACTUAL_USAGE,
       ITEM,
       DESCRIPTION
FROM JOB_ROUTERS
LEFT JOIN ITEM_ATTRIBUTE
       ON JOBS.ITEM_NUMBER == ITEM_ATTRIBUTE.ITEM
WHERE RESOURCE_CODE == "TDWELD"