With the left join, the results table contains all fields of the left table and only those fields of the right table for which the content of the linked fields is the same.
对于左向连结，结果表格含有左侧表格中的所有字段，以及右侧表格中其链接字段具有相同内容的那部分字段。