When a blend is created using the join key of Category, a left join is established. In a left join, all records from the primary table (Table A in this case) are included in the result, along with the matching records from the secondary table (Table B). If there is no match, the result from the secondary table will be NULL. This allows all the data from Table A to be retained, while corresponding data from Table B is included wherever matches are found.