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