select a.name,b.IndName from members a, IndstryMast b,
Member_Industry c where
a.member_id = c.Member_Id and b.SrNo = c.Industry_id