The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value

Kindly assist on the below;   I am trying to filter one table using the column from another table (date type), however, I get the error "The expression refers to multiple columns. Multiple columns ca...