如何在1个查询中以1：n关系计算两个表中的所有记录？

I'm guessing this a fairly easy question, but I've run into this problem a number of times and I can't find a solution either through searching (maybe I don't know what to search for) or trial and error.I'm guessing this a fairly easy question, but I