Sam
Member since Nov 29, 2011
- Profile: /members/9318-sam.htm
- Comments: 1
Recent Blog Comments By Sam
-
Getting One Record Per Group From A One-to-Many Join
Posted on Nov 29, 2011 at 1:17 AM
How about: select c.name, <!--- Phone data. ---> ( p.name ) AS phone_number, ( p.ext ) AS phone_ext, ( ISNULL( p.is_preferred, 0 ) ) AS is_preferred FROM @contact c LEFT OUTER JOIN @phone p c.id = p.id group by c.id order by is_preferred, p.name... read more »