I have his query that works fine, but I need it to return a line when nothing is found to suit the conditions:

```
SELECT D.CODPRO, D.VALPRO, COALESCE(SUM(d.UVCLIV), 0)  AS SUM 
FROM FGE50LM0TV.GESUPE E LEFT JOIN FGE50LM0TV.GESUPD D   
ON E.NUMSUP=D.NUMSUP AND E.SNUSUP=D.SNUSUP               
WHERE E.CODACT = '001'                                         
AND D.CODPRO <> ''                                       
AND E.CIRPIC = 'HUB'                                     
AND E.ETASUP IN ('30','40','60')                         
AND D.CNFLIG = '2'                                       
AND E.TOPMNQ <> '1'                                      
AND D.CODPRO IN ('TST UOP 1')                                 
GROUP BY D.CODACT, D.CODPRO, D.VALPRO 

```

Maybe the question is not that clear.
Let me simplify it:

I want the following query to return the CODPRO, VALPRO, 0 as SUM of UVCLIV when CNFLIG is <> of '2':

```
SELECT CODPRO, VALPRO, COALESCE(SUM(UVCLIV), 0)  AS SUM 
FROM FGE50LM0TV.GESUPD                              
WHERE CNFLIG = '2'                                                                          
AND CODPRO IN ('TST UOP 1')                                 
GROUP BY CODACT, CODPRO, VALPRO ;

```

This is what I have for this product now in the table:

[![enter image description here](https://i.stack.imgur.com/G7M4E.png)](https://i.stack.imgur.com/G7M4E.png)

I use this query to insert a line of PRODUCT, VARIANT, QUANTITY into a file (H) by making a sum of all lines with that PRODUCT/VARIANT from another file (D). I have all those conditions that I wrote, and I want to receive a line with the PRODUCT, VARIANT, 0 as SUM for the situation when the SQL does not find anything according to my conditions.

I am not using MySQL workbench. I am on an IBM Emulator Utility v 14.14