The syntax is incorrect. If there are two qualifying rows, then which of the two fnames would you want to select?
If you know there is only ever going to be one unique fname for your selection, then you can simply add "GROUP BY fname" to your query.
if you want something else, then you first have to tell what you want before you can get proper advice on a solution.
Gert-Jan
No comments:
Post a Comment