How to join streams

What is the best method to join two streams by a field?
Basically I’m looking for the equivalent of SQL INNER JOIN where I join two tables by a field

I read about projections and subscriptions but not sure what to use

What are you going to do with the resulting events from the 2 streams ?

I want to query the data and display it to the user

Lets say I have one stream that has score change events and second stream that has questionnaires change events (changes in responses to questions).
I would like to be able to show the user that the score has changed from X to Y because he answered A to question Q1 and B to question Q2.
I have a unique id that is common between the score change event and questionnaire change event so would like to join the two streams based on that unique id