Q&A for pro webmasters
SELECT Posts.Id AS "Id.x", Users.Id AS "Id.y", Users.UpVotes FROM Posts LEFT JOIN Users ON (Posts.Id = Users.Id)