[步骤]
原逻辑:
SELECT
t.id,
t.source_id,
t.msku,
t.inventory_age_181_to_270_days,
inventory_age_271_to_365_days,
inventory_age_365_plus_days
FROM
t_amz_fba_virtual_inventory t
INNER JOIN (
SELECT
source_id,
msku,
max( id ) AS max_id
FROM
t_amz_fba_virtual_inventory
WHERE
source_id = 10327
AND msku IN ( '3113R1199IOUH8' )
AND is_deleted = 0
GROUP BY
source_id,
msku
) t1 ON t.source_id = t1.source_id
AND t.msku = t1.msku
AND t.id = t1.max_id
新逻辑:
SELECT * FROM `zhcxkj-center-datasync`.t_amz_fba_manage_inventory_health_report where sku ='3113R1199IOUH8'

[结果]
[期望]