在多对多关联的时候，数据库抛出错误 [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]关键字 'PIVOT' 附近有语法错误。 (156)
同样的代码在mysql下是正常的，应该是PIVOT没有用[]括起来导致的。错误的sql 语句如下
SELECT
T1.*
FROM
(
SELECT
thinkphp.*,
ROW_NUMBER () OVER (
ORDER BY
rand()) AS ROW_NUMBER
FROM
(
SELECT
[rooms].*,
PIVOT.id AS pivot__id,
PIVOT.user_id AS pivot__user_id,
PIVOT.rooms_id AS pivot__rooms_id,
PIVOT.c_time AS pivot__c_time,
PIVOT.del_time AS pivot__del_time
FROM
[rooms]
INNER JOIN [user_rooms_relation] [pivot] ON [pivot].[rooms_id] = [rooms].[id]
WHERE
( [pivot].[user_id] = '1' )
AND [rooms].[del_time] IS NULL
) AS thinkphp
) AS T1
最佳答案
