select on distinct field plus the rest

[dodozhang21]

hi, i'm stuck on a simple query.

i want to select from a table and making sure one of the field is distinct but i also want to select other fields. i tried something like

SELECT *,distinct msgfrom FROM xmb_star_m_app WHERE dateline>'$last20days'

but it's not working. i can't seem to figure out the right syntax to do what i want. any help is appreciated.

[ahundiak]

Flip over to the mysql.com web site and read up on the distinct keyword. Basically, you can't do what you want to do with distinct though group by might help.