SELECT DISTINCT doesn't work on browse form

[guscastro]

I should be missing something.
I put this code below into the SQL box of a form

Code: Select all

select distinct `title_type` FROM `la_contacts` 

I tested the code direct on the MYSQL panel and it works perfect but on the nu app the DISCTINCT is ignored and it browse all the records.
Please help

[admin]

guscastro,

Your sql needs to contain the Form's Primary Key

Steven