Error Message
SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'pivot'.
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [re_item].*,pivot.id AS pivot__id,pivot.re_server_id AS pivot__re_server_id,pivot.re_item_id AS pivot__re_item_id FROM [re_item] INNER JOIN [re_server_item] [pivot] ON [pivot].[re_server_id]=[re_item].[id] WHERE [pivot].[re_item_id] = '1') AS thinkphp) AS T1
但是我在原生sql 语句里加粗的代码pivot上加了[ ],就能查出数据
最佳答案
