尝试使用表变量代替类似：
DECLARE @Per TABLE (PerID bigint NOT NULL......)DECLARE @Pre TABLE (PerID bigint NOT NULL, IsWorking.......)INSERT INTO @Per SELECt .... FROM .....INSERT INTO @Pre SELECt .... FROM .....SELECt * FROM @Per per LEFT JOIN @Pre pre ON per.PerID = pre.PerID
应该工作正常
