执行公共表表达式时出现语法错误

您可能只是缺少一个逗号:

with b as (
      SELECT *
      FROM [Core].[dbo].[SalesAccount]
      WHERE [SalesAccount].[RecordUpdateDate] > '2014-07-15'
     ),
     a as (
      SELECT *
      FROM [Core].[dbo].[SalesActivity]
     ) 
SELECT *
FROM a INNER JOIN
     b
     on a.SalesAccountSFID = b.SalesAccountSFID;

没有理由为此使用CTEs。我发现这更简单:

SELECT sa.*, sact.*
FROM [Core].[dbo].[SalesAccount] sa INNER JOIN
     [Core].[dbo].[SalesActivity] sact
     on sa.SalesAccountSFID = sact.SalesAccountSFID
WHERE a.RecordUpdateDate > '2014-07-15';