Mine

SELECT CAFES.ITEM_NO, CAFES.ITEM_CAFE AS RECIPE, MOUTURES.LIST_ELEMENT AS MOUTURE, PRODUCT_TYPES.LIST_ELEMENT AS PRODUCT_TYPE, CONSERVATIONS.LIST_ELEMENT AS CONSERVATION, CAFES.NBR_SACS, CAFES.POIDS, CAFES.POIDS_UDM, BOX_DESC.DESCR AS BOX_DESC, FILM_DESC.DESCR AS FILM_DESC, PROD_DESC.DESCR AS PROD_DESC, CAFES.OLD_LABEL_INFO, CAFES.PROD_NOTE, CAFES.NBR_SUB_CONTAINER, CAFES.SUB_CONTAINER_ACTIF, CAFES.ILAPAK_PROG, CAFES.QTE_FILTRES, CONTENANTS.LIST_ELEMENT AS SUB_CONTAINER FROM ZZVITTO_WZ_CAFE CAFES INNER JOIN WZ_LISTS_DTL MOUTURES ON CAFES.MOUTURE = MOUTURES.LINE_ORDER AND MOUTURES.LIST_NAME = 'MOUTURE'INNER JOIN WZ_LISTS_DTL PRODUCT_TYPES ON CAFES.PRODUCT_TYPE = PRODUCT_TYPES.LINE_ORDER AND PRODUCT_TYPES.LIST_NAME = 'TYPE_PRODUIT' INNER JOIN WZ_LISTS_DTL CONSERVATIONS ON CAFES.CONSERVATION = CONSERVATIONS.LINE_ORDER AND CONSERVATIONS.LIST_NAME = 'CONSERVATION'INNER JOIN ITEM_DESC BOX_DESC ON CAFES.ITEM_BOITE = BOX_DESC.REF_NO AND BOX_DESC.LANG_NO = 'F' INNER JOIN ITEM_DESC FILM_DESC ON CAFES.ITEM_FILM = FILM_DESC.REF_NO AND FILM_DESC.LANG_NO = 'F'INNER JOIN ITEM_DESC PROD_DESC ON CAFES.ITEM_NO = PROD_DESC.REF_NO AND PROD_DESC.LANG_NO = 'F'LEFT OUTER JOIN WZ_LISTS_DTL CONTENANTS ON CAFES.SUB_CONTAINER = CONTENANTS.LINE_ORDER AND CONTENANTS.LIST_NAME = 'CONTENANTS'WHERE (CAFES.ITEM_NO = '10235')