Question Davidson Faria · Jul 22, 2021 Strange query result Can someone tell me why this query select vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf, vet.numConselho, vet.nome, svp.SEQ_SOLICITANTE, vet.numConselho , vlab.numConselho from RPE.Veterinario vet inner join RPE.VeterinarioLab vlab ON vet.conselho = vlab.conselho AND vet.numConselho = vlab.numConselho AND vet.uf = vlab.uf left join MySevi.SolicitanteVeterinarioPaciente svp on svp.ID_VETERINARIO = vet.ID where svp.ID_PACIENTE in ('6408||284144||47633', '6408||284145||47634') does't return any value and this query #Caché 0 4 0 227