<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hello,<div><br></div><div><br><div>Vs 3.6 : problem with distinct on varchar</div><div><br></div><div>This query doesn't work and returns a kernel error (<span class="Apple-style-span" style="color: rgb(255, 0, 0); font-family: Monaco; font-size: 12px; ">Kernel error: 0xffffffd9) :</span></div><div>SELECT distinct nom FROM _type_couverture, _jonction_album WHERE (_type_couverture.recID= idCouverture AND idPage = 2 AND idAlbum = 6 AND idReliure=2) </div><div><br></div><div>BUT</div><div><br></div><div>This query works fine (except that I have same results several times) :</div><div><br></div><div><div>SELECT nom FROM _type_couverture, _jonction_album WHERE (_type_couverture.recID= idCouverture AND idPage = 2 AND idAlbum = 6 AND idReliure=2) </div><div><br></div><div><br></div><div>Field "nom" is varchar 128.</div><div><br></div><div>How can I get the distinct results ?</div><div><br></div><div><br></div><div>br</div><div>Christian</div><div><br></div></div></div></body></html>