Simple SQL Join Query Syntax Issue

I am running a Select Statement by fetching values from Multiple Tables.

I have

Member  Table
MemberInsuranceCompany Table
InsuranceCompanies Table

MemberInsuranceCompany Tables carries InsuranceCompanyId and MemberId.
InsuranceCompanies Tables carries only Insurance details ..!
I need to fetch MemberName and his Insurance Company.

Can you please guide me in the syntax ..!

select Mem.LastName + ','+ Mem.FirstName as [MemberName],
 Rx.RxproName,DOB
-- ,IC.ICName 
from memberstatus MS 
inner join Members Mem
on Mem.MemberId = MS.MemberId
inner join Rxprocessors Rx
on Rx.RxProcessorId = Mem.RxProcessorId
inner join MemberInsuranceCompany MIC
on MIC.MemberId = Mem.MemberId
--inner Join InsuranceCompanies
--on	IC.InsuranceCompanyId = MIC.InsuranceCompanyId
where MS.status = 'A'

Select allOpen in new window