Posted by Plamen Ratchev on 02/01/08 18:50
> "SirCodesALot" <sjourdan@gmail.com> wrote in message
> news:16b1e4df-ab63-4c7c-85ef-022ff89f68a4@e23g2000prf.googlegroups.com...
> Why does adding another select column cause the Distinct on the
> u.title to fail? I should have taken more DB courses :)
DISTINCT applies to the whole row, not only to one or two columns.
Plamen Ratchev
http://www.SQLStudio.com
Navigation:
[Reply to this message]
|