[亚马逊](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

Answer 1

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