Problem With Distinct Option

Hi,

I have setup a basic page to display the username and address field, but when I enable to distinct field I get the following error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid), users.name AS users_name, users.uid AS users_uid FROM' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), users.name AS users_name, users.uid AS users_uid FROM node node INNER JOIN users users ON node.uid = users.uid ORDER BY users_name ASC in /home/webp/public_html/modules/views/includes/view.inc on line 727.

Please can you advise.

Cheers