Pongo La Consulta Exactamente Igual y me arroja este error
Cita: Msg 8120, Level 16, State 1, Line 1
Column 'miTabla.Nombre' is invalid in the select list because it is not containde in either an aggregate function or the GROUP BY clause.
ese error me sale..