Yii生成的SQL如下:
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 [t].[id] AS [t0_c0], [t].[title] AS [t0_c1], [t].[content] AS [t0_c2], [t].[tags] AS [t0_c3], [t].[status] AS [t0_c4], [t].[create_time] AS [t0_c5], [t].[update_time] AS [t0_c6], [t].[author_id] AS [t0_c7] FROM [dbo].[tbl_post] [t] WHERE (status=2) ORDER BY update_time DESC) as [__inner top table__] ORDER BY update_time ASC) as [__outer top table__] ORDER BY update_time DESC
SQL SERVER 2008 报错:
消息 207,级别 16,状态 1,第 1 行
列名 'update_time' 无效。
消息 207,级别 16,状态 1,第 1 行
列名 'update_time' 无效。
嵌套查询的里面已经赋了别名,外面取到的列名就是别名了,这里的列名’update_time’应该是[t0_c6]