Column 'page_time' in field list is ambiguous.

Viewed 8

Doris版本:doris-2.1.11-rc01
有两张主键表:table_1和table_2
table_1字段:news_id、page_time、title
table_2字段:news_id、page_time、content
两个表的id、page_time都是相同的

select
pip.news_id
from table_1 pip
J0IN table_2 nc ON pip.news_id = nc.news_id
where pip.page_time >= '2025-09-25 22:04:00
AND pip.page_time <= '2025-12-26 22:04:00'
AND nc.page_time >= '2025-09-25 22:04:00'
AND nc.page_time <= '2025-12-26 22:04:00'
AND(
NOT MATCH_PHRASE (pip.titLe,'鱤')
OR NOT MATCH_PHRASE (nc.content,'')
)
LIMIT 10;

执行上述sql,提示:
errCode = 2, detailMessage = Column 'page_time' in field list is ambiguous.

0 Answers