Olá pessoal, blza? Estou com uma dificuldade nessa consulta
ERRO
Erro ao acessar o banco de dados
[Sybase][ODBC Driver][SQL Anywhere]Column ‘codi_emp’ found in more than one table or it is used more than once in the SELECT list – it needs a correlation name
SelectLimit(SELECT codi_emp from (select * from (select bethadba.efmvepro.codi_emp, SUM(bethadba.efmvepro.vlor_mep) AS ENTRADA from bethadba.efmvepro where bethadba.efmvepro.cfop_mep IN (‘1102’,‘2102’) AND bethadba.efmvepro.data_mep between ‘2014.04.01’ and ‘2014.04.30’ group by bethadba.efmvepro.codi_emp ) as entrad, ( select bethadba.efmvspro.codi_emp, SUM(bethadba.efmvspro.vpro_msp) AS SAIDA from bethadba.efmvspro where bethadba.efmvspro.cfop_msp IN (‘5102’,‘5403’) AND bethadba.efmvspro.data_msp between ‘2014.04.01’ and ‘2014.04.30’ group by bethadba.efmvspro.codi_emp ) as said where entrad.codi_emp = said.codi_emp) nm_sel_esp , 12, 0)
No SQL Builder ele traz a consulta certinha, mas na aplicação retorna esse erro. Percebi q o SC cria uma expressão SELECT antes do script… acredito que seja aí o problema.
Agradeço mto quem puder me ajudar em qualquer coisa.
Obrigado