Take by default zero value when no value present

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1 
group by RQO_ORG
         Union
         select  '4' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1
          union 
         select  '26' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1
          union 
         select  '30' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1
          union 
         select  '61' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1)
2

I see a database query. I don't see sample output or desired output. What are you trying to do that your current query isn't doing for you?

3

On a further note, the query seems to be syntactically flawed, as the closing bracket in the last line is nowhere opened before and there is no ending semicolon, which is required as a line-ending in SQL.

I hope this helps.

bakunin