go to post Martin Weissenborn · Aug 26, 2021 Try %ignoreindices * perheps you have a problem with the indicesIf you get an result you must rebuild the indices. select vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf, vet.numConselho, vet.nome, svp.SEQ_SOLICITANTE, vet.numConselho , vlab.numConselho from %ignoreindices * RPE.Veterinario vet inner join RPE.VeterinarioLab vlab ON vet.conselho = vlab.conselho AND vet.numConselho = vlab.numConselho AND vet.uf = vlab.ufleft join MySevi.SolicitanteVeterinarioPaciente svp on svp.ID_VETERINARIO = vet.ID where svp.ID_PACIENTE in ('6408||284144||47633', '6408||284145||47634')