Unmatched Inventory Movements Reconciliation

Reconcile ledger and scanner inventory movements by reference_code and product_id. Return records missing from either side or having different quantities. Emulate a full outer join in SQLite. Return reference_code, product_id, ledger_qty, scanner_qty and issue. Return columns: reference_code, product_id, ledger_qty, scanner_qty, issue.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Reconcile ledger and scanner inventory movements by reference_code and product_id. Return records missing from either side or having different quantities. Emulate a full outer join in SQLite. Return reference_code, product_id, ledger_qty, scanner_qty and issue. Return columns: reference_code, product_id, ledger_qty, scanner_qty, issue.

Difficulty: Expert
SQL concept: INNER JOIN