I've done that by using 'select distinct' but once a data change in view a messsage will appear that key field in the original fiel is not unique.