gpt4 book ai didi

php - SQL 错误 : column ambiguously defined with subquery

转载 作者:行者123 更新时间:2023-12-02 04:40:36 24 4
gpt4 key购买 nike

<分区>

我正在尝试进行分页显示,我以前用这种模式取得过成功,但由于某种原因这个模式不起作用:

这有效,

select e.data,e.onorar,d.data,d.suma 
from contract_j e
join rata d on e.id_cj = d.id_cj
join persoana l on l.id_p = e.id_avocat

但这不是

select * from (
select a.*, rownum as rnum from (

select e.data,e.onorar,d.data,d.suma
from contract_j e
join rata d on e.id_cj = d.id_cj
join persoana l on l.id_p = e.id_avocat) a

where rownum <= :maxrow)
where rnum >= :minrow

它说在第 2 行模糊定义了列

为什么?想不通了。。

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com