How to get multiple list of arrays from stored procedures.

Question

Hi,

 

I have three tables Sessions, SessionSpeakerMapping, Speakers .

 

SessionSpeakerMapping table contains SessionId and SpeakerId.

 

I created get sessions procedure.

 

I want to get list of speakers related to particular session.

 

Please give me any suggestions.