Edit

Order

Name

Query select ic.ListName as 'Carrier Name', isnull(ic.Ledger,'') as 'Ledger', isnull(ml1.Description,'') 'CollGroup', ml2.Description AS 'CarrierType', ml3.Description as 'FinancialClass', isnull(ig.Name,'') as'Insurance Group' from InsuranceCarriers ic LEFT JOIN MedLists ml1 on ml1.TableName='CollectionsGroup' and ml1.MedListsId = ic.CollectionsGroupMId LEFT JOIN MedLists ml2 on ml2.TableNAme='CarrierTypes' and ml2.MedListsId = ic.CarrierTypeMId LEFT JOIN MedLists ml3 on ml3.TableNAme='FinancialClass' and ml3.MedListsId = ic.FinancialClassMId LEFT JOIN InsuranceGroup ig on ig.InsuranceGroupId = ic.InsuranceGroupId order by ic.ListName

Notes