I made a prototype of a informix database in Access to optimize the construction of my queries. I use with MySQL and through some syntax adjustments I get a good one.
But in%% of% I can not. I want to believe it's a little detail but I'm not finding it.
The relationships between the tables are the ones I've set up in Access :
QueryingthebankinformixIdidasfollows:
SELECTcnnfcapa.tpordem,cnnfcapa.id_agente,cnnfcapa.id_agentvext,cmgrupos.id_grupos,cnnfitem.desritem,cnnfitem.mercadoria,cnnfitem.quantidade,cnnfitem.valoritem,0ASrsrv,(cnnfitem.valoritem-cnnfitem.customedio')ASlprdFROMcmgruposINNERJOINcscapasINNERJOINcnnfcapaINNERJOINcnnfitemONcnnfcapa.id_nfcapa=cnnfitem.id_nfcapaANDcscapas.ordemserv=cnnfcapa.ordemservINNERJOINcttransaONcnnfcapa.transacao=cttransa.transacaoANDcmgrupos.id_grupos=cnnfitem.idgruposINNERJOINcipessoaINNERJOINciendereONcipessoa.cgccpf=ciendere.cgccpfANDcnnfcapa.nro_proprietario=ciendere.nro_endereWHEREcnnfitem.tpitem"<>2"
AND cttransa.mvtotransacao Like "S"
AND cttransa.tipotransacao Like 10
Where am I going wrong?