Get Column from another table by applying filter

Hi everyone, I have the following query:

I have table A and table B. Between tables A and B I have a common field as a key, it's called Camp_ID.

Table A is my main table with data. From table B, I need to filter the rows where the Category field starts with 'Spring*' and get column End_Date from that table and take it to table A.

How can I go about filtering the data in Table B and bringing me to Table A in column End_Date? You wouldn't need to have table B in the model, it's just to get that field.

Thank you!!!