我正在努力實作以下目標...
with
relations as (
select
rm.recordId,
rs.fieldId,
rm.relationSettingId,
rm.relatedRecordId
from relationMapping rm
left join relationSetting rs on rs.id = rm.relationSettingId
),
foo as (
select distinct
coalesce(rnff.fieldId, field.id)
from field
left join relationNameFromField rnff
on rnff.relationSettingId = relations.relationSettingId -- <---- Won't work
)
select * from foo;
我收到以下錯誤：
Unknown column 'relations.relationSettingId' in 'on clause'
為什么我不能參考relations表格？
uj5u.com熱心網友回復：
根據您的 CTE，這只是一個猜測，但我認為您可能想要：
with
relations as (
select
rm.recordId,
rs.fieldId,
rm.relationSettingId,
rm.relatedRecordId
from relationMapping rm
left join relationSetting rs
on rs.id = rm.relationSettingId
),
foo as (
select distinct
coalesce(rnff.fieldId, field.id)
from field
left join relations --add this join here
on field.id = relations.fieldId
left join relationNameFromField rnff
on rnff.relationSettingId = relations.relationSettingId
)
select * from foo;
我們不知道您的表結構，所以我不能說我有適合該連接的列，但我會說這是一個很有根據的猜測。
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/422034.html
標籤：