56,675
社区成员
发帖
与我相关
我的任务
分享
select brand1,brand2
from (select row_number()over(order by getdate())id,brand1 from icf_result)a inner join
(select row_number()over(order by getdate())id,brand2 from icf_result1)b on a.id=b.id
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(order by getdate())id,brand1 from icf_result)a inner join
(select row_number()' at line 2select brand1,brand2
from (select row_number()over(order by getdate())id,brand1 from tb1)a inner join
(select row_number()over(order by getdate())id,brand2 from tb2)b on a.id=b.id