sql - [Amazon](500310) 无效操作：对表“fact_spv_commissioned_lot”的 FROM 子句条目的无效引用；

Question

我在 stackoverflow 上查看了一些类似的问题，但没有一个对我有帮助。无论我做什么，我都会不断收到此错误。

亚马逊无效操作：对表“fact_spv_commissioned_lot”的 FROM 子句条目的无效引用；

SELECT COUNT(*) FROM staging_serials s
  JOIN dim_md_company c ON (c.lsc_company_id = s.companyid)
  JOIN staging_product p ON (s.compositeproductcode = p.compositeproductcode)
  JOIN dim_packaging_level l ON (l.unit_of_measure = p.packaginguom)
WHERE c.sk_company_id = fact_spv_commissioned_lot.sk_company_id
  AND s.lotnumber = fact_spv_commissioned_lot.lot_number
  and p.sk_product_id = fact_spv_commissioned_lot.sk_product_id
  and l.sk_packaging_level_id = fact_spv_commissioned_lot.sk_packaging_level_id

标签： sqlamazon-redshift

Answer 1

因为fact_spv_commissioned_lot没有列在查询的表子句中。您正在加入staging_serials、dim_md_company、staging_product和dim_packaging_level表。您需要包括fact_spv_commissioned_lot表格。