易兒善

首先建立三张表如下：分别加入数据如下：内连接 INNER JOINsql:SELECT [t0].[Id], [t0].[Name], [t1].[GroupName], [t2].[Salary] AS [Content]FROM [User] AS [t0]INNER JOIN [Group] AS [t1] ON [t0].[GroupId] = ([t1].[Id])INNER JOI

借助于匿名类型：和解决按多条件分组的思路相同。from c in CustomerLegalOrgsjoin ao in AccountingOrganizationConfigs on c.OrganizationId equals ao.OrganizationIdjoin ac in AccountingCustomerConfigs on c.CustomerLegalId equals