SELECT a.*, b.ITM_CATEGORYNAME FROM M_TBL_PRODUCT a, M_TBL_ITM_CATEGORY b WHERE a.PROD_CODE=585 AND b.ITMCAT_ACTIVE='Y' AND a.ITM_CATCODE=b.ITM_CATCODE