How to pass cascade parameters in sql

Question

I have a table in which i have First table(recordid,insertionid,year,name)Values(1,21,2008,Danish)

Now I am binding these records to a gridview using store procedure , The issue is that I want to get the  the value from another table where insertionid(as foriegn key) mean another table 

secondtable(id,insertionid(f),Questionid) Now I want to get  the QuestionId by passing the insertionid which i have in first table , and then pass this questionid  as parameter and get the question text from another table Thirdtable(id,QuestionId,QuestionText) so cascaded nature of parameter how to get that using store procedure write full code any one can assist pls