select
    empresa,
    email,
    obrigacao
from (
        select
            total.empresa,
            total.email,
            total.obrigacao,
            (case when
                (coalesce(local.empresa,'') = ''
                 and coalesce(ws.empresa,'') <> '')
                 and (coalesce(local.email,'') = ''
                 and coalesce(ws.email,'') <> '')
                 and (coalesce(local.obrigacao,'') = ''
                 and coalesce(ws.obrigacao,'') <> '')
            then -1
            else 0
            end) as resultado
            from ('alguma query'

            union

            select
                usu.empresa,
                usu.email,
                emp.obrigacao
            from admusuariosempresassistemasitensportal usu
            join (
                select
                    aoe.empresa,
                    aoe.obrigacao,
                    ao.sistema
                from (
                    select
                        empresa,
                        obrigacao
                    from admcontroleadministrativo
                    where empresa =
                        and obrigacao =
                        and obrigacaoextra = -1
                    group by empresa, obrigacao
                     ) aoe
                join admobrigacoes ao on ao.obrigacao = aoe.obrigacao
                group by aoe.empresa, aoe.obrigacao, ao.sistema) emp on emp.empresa = usu.empresa
                                                                     And emp.sistema = usu.sistema
                 ) total
            left join (
                    select
                        cast('LOCAL' as varchar) as origem,
                        a.empresa,
                        a.email,
                        a.obrigacao
                    from (
                        select
                            usu.empresa,
                            usu.email,
                            emp.obrigacao
                        from admusuariosempresassistemasitensportal usu
                        join (
                            select
                                aoe.empresa,
                                aoe.obrigacao,
                                ao.sistema
                            from (
                                select
                                    empresa,
                                    obrigacao
                                from admcontroleadministrativo
                                where empresa =
                                and obrigacao =
                                and obrigacaoextra = -1
                                group by empresa, obrigacao) aoe
                            join admobrigacoes ao on ao.obrigacao = aoe.obrigacao
                            group by aoe.empresa, aoe.obrigacao, ao.sistema) emp on emp.empresa = usu.empresa
                                                                                And emp.sistema = usu.sistema) a) local on local.empresa = total.empresa
                                                                                                                        And local.email = total.email
                                                                                                                        And local.obrigacao = total.obrigacao
                        left join (outra query) ws on ws.empresa = total.empresa
                                                    And ws.email = total.email
                                                    And ws.obrigacao = total.obrigacao) r
where r.resultado = -1