Identify Assembly and Component Product Reconcile Group Mismatch

SELECT x.assy_product_code,x.comp_product_code,pa.reconcile_group,pc.reconcile_group
FROM artprstr x
inner join artprod pa on pa.product_code=x.assy_product_code
inner join artprod pc on pc.product_code=x.comp_product_code
where pa.reconcile_group<>pc.reconcile_group