sybase有多个left join 和多个union会报错

最新推荐文章于 2021-08-18 16:30:03 发布

原创最新推荐文章于 2021-08-18 16:30:03 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sybase left jion uni

本文解决了一个在使用ANSI SQL语法时遇到的Sybase数据库错误，具体错误信息为AdaptiveServer无法执行请求的操作，因为列'organId'不在连接表达式的范围内。通过调整查询语句结构，将外联接操作分解，避免了使用内部包含UNION的衍生表，从而解决了问题。最后，作者创建了一个视图来替代原始的查询结构。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错内容：

Adaptive Server cannot perform the requested action because column

'organId' is not within the scope of the joined table expression.Check

your command for missing or incorrect database objects,variable names,

and/or input data.

select ...

from

left join

on t1=t2

left join

(

select ... from t3

union all

select ... from t4

）t5

on t1=t5

这样写会报错。

原因：Hi, it was a limatation of Sybase in the end when using ANSI sql or at least thats what the DBA's told me. A derived table is seen as an inline view in the SQL BO generates, Sybase can handle that but if the inline view contains a union (so your derived table has a union) and there are 3 or more other tables joined with the SQL it throws this error, works fine if only two tables, or if you break the union up into two derived tables. In the end I created the view on the db. I find Sybase frustrating no decode no MINUS commands

Thanks