Two Different Table but some Common Fields data inserting

Question

Hello,

 

I have developed an C# windows application where i have Two tables like MMMEMBER and MMSH_MAST and in MMMEMBER table Common Fields are MNO,OP_DT now in that table i have already enterd both fields data and now in my application i have fetch that data when combobox select any MemberNo it's related data will display in textboxs through Store Procedure and in My Second MMSH_MAST table MNO and OP_DT fields are common now how can i get these two fiedls data autometically form MMMEMBER table suggest me query for that.

Thanks..