主题：多表联合查询的分页问题SQLTABLE SQLLOAD

Select * F rom (Select Row_Number() Over(Order by [订单ID]) As RowNum, * f rom 订单) As a Where RowNum >= 1 And RowNum <= 50

这行是示例

我现在需要查询两个表

一个是tbl_商品 另一个是tbl_品牌表

靠tbl_商品.品牌=tbl_品牌表.品牌名称 联合

请问以上SQL 代码要怎么套用？

1、首先得到联合查询的sql语句，比如为 sql1；

 

2、把sql1替换示例语句的【订单】即可，如

 

Select * F rom (Select Row_Number() Over(Order by [订单ID]) As RowNum, * f rom (sql1)) As a Where RowNum >= 1 And RowNum <= 50

好像不行 我把SELECT 语句 直接写在了SQL1那里 显示不行

此主题相关图片如下：1535373725(1).jpg
我这样写 还是不行 特意没有多表查询

此主题相关图片如下：1535373857(1).jpg

Select * F rom (Select Row_Number() Over(Order by [订单ID]) As RowNum, * f rom (sql1) as a) As a Where RowNum >= 1 And RowNum <= 50

Select * F rom (Select Row_Number() Over(Order by [登记名称]) As RowNum, * f rom (SELECT [tbl_商品]._identify [tbl_商品].品牌,登记名称 f rom  [tbl_商品])as a) As a Where RowNum >= 1 And RowNum <= 40

Select * F rom (Select Row_Number() Over(Order by [登记名称]) As RowNum, * f rom (SELECT [tbl_商品].[_identify], [tbl_商品].品牌,登记名称 f rom  [tbl_商品])as a) As a Where RowNum >= 1 And RowNum <= 40