SELECT DISTINCT R.RECIPE_NO, F.FORMULA_NO, F.FORMULA_VERS FROM GMD_RECIPES R, FM_FORM_MST F, GMD_STATUS S WHERE S.STATUS_CODE = R.RECIPE_STATUS AND R.DELETE_MARK = 0 AND R.FORMULA_ID = F.FORMULA_ID
View Text - HTML Formatted
SELECT DISTINCT R.RECIPE_NO , F.FORMULA_NO , F.FORMULA_VERS FROM GMD_RECIPES R , FM_FORM_MST F , GMD_STATUS S WHERE S.STATUS_CODE = R.RECIPE_STATUS AND R.DELETE_MARK = 0 AND R.FORMULA_ID = F.FORMULA_ID