在关键字'('附近有语法错误 Incorrect syntax near '(' in sql server table values function

from dbo.ocm_map_PositionRelation pp left join 

dbo.[fun_GetAsIsPEPropertyExtent](getdate()) ps on pp.PositionId = ps.PositionID

解决方法:

1. You need CROSS or OUTER APPLY
2. You need to be on SQL Server 2005+
3. And most important, the database compatibility needs to be 90 or higher