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