How to Create a Stored Procedure for Two Tables ?

Question

Hi,

        I have Created Three Tables .First two tables i bind it to 2 different dropdowns and the third table i have some data. I want to create a Stored Procedure .Depending UpOn selection of two ddls the data should be populated to listbox(i.e Data frm 3rd Table).Please tell the sp for it

Thanks.