#### Pendencias por Empresa/Tabela SELECT TACAO.CODI_EMP, TTABELA.CODIGO, TTABELA.TABELA, COUNT() AS TOTAL FROM BETHADBA.GEATENDIMENTOACOES AS TACAO INNER JOIN BETHADBA.GEATENDIMENTOTABELASTRANSFERIR AS TTABELA ON (TTABELA.CODIGO = TACAO.CODIGO_TABELA) WHERE TTABELA.GRUPO IN (20,16) AND TACAO.STATUS!= -1 GROUP BY TACAO.CODI_EMP, TTABELA.CODIGO, TTABELA.TABELA ORDER BY TACAO.CODI_EMP, TTABELA.TABELA #### Pendencias por Tabela SELECT TTABELA.CODIGO, TTABELA.TABELA, COUNT() AS TOTAL FROM BETHADBA.GEATENDIMENTOACOES AS TACAO INNER JOIN BETHADBA.GEATENDIMENTOTABELASTRANSFERIR AS TTABELA ON (TTABELA.CODIGO = TACAO.CODIGO_TABELA) WHERE TTABELA.GRUPO IN (20,16) AND TACAO.STATUS!= -1 GROUP BY TTABELA.CODIGO, TTABELA.TABELA ORDER BY TTABELA.TABELA