Why if i add new join to query return all the rows from the join table?

I have this query that return 2 rows

How To Pass Symmetric Key to query

I want to know how to pass symmetric key to SQL Query as parameter.