Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
SELECT top 10 u.DisplayName, p.Body FROM Posts p LEFT OUTER JOIN Users u ON p.OwnerUserId = u.Id