在[aoe:AbstractOrderEntry, oe:OrderEntryItem]中找不到别名o的(可见)类型.&

Question

我正试图通过BaseStoreModel过滤在灵活的搜索查询(OrderEntryItem和AbstractOrderEntry)中加入2个表

select {oe.pk} from {OrderEntryItem as oe join AbstractOrderEntry as aoe on {oe.abstractOrderEntry} = {aoe.pk}} where {aoe.order} in (select {o.pk} from {AbstractOrder as o where {o.store} = ?store)

但是我有以下错误:

在[aoe:AbstractOrderEntry, oe:OrderEntryItem]中找不到别名o的(可见)类型

Answer 1

可以使用EXISTS来代替IN关键字。你可以从中得到支持。链接

如果你想使用"IN"关键字，你有语法问题。你需要使用两个花括号。

例如,

SELECT {PK} FROM {Product} WHERE {code} IN ( {{ SELECT {code} FROM {Product} WHERE {unit}=unit1 }})