Example: Table Joins With ON

example-table-joins-with-on.sql

SELECT ie.name "invoice_number", 
       pj.name "payment_journal", 
       apr.amount "reconciliation_amount"
FROM account_move_line iel --- invoice entry line
INNER JOIN account_move ie --- invoice entry
    ON iel.move_id = ie.id
INNER JOIN account_partial_reconcile apr 
    ON apr.debit_move_id = iel.id
INNER JOIN account_move_line pel --- payment entry line
    ON apr.credit_move_id = pel.id
INNER JOIN account_move pe --- payment entry
    ON pel.move_id = pe.id
INNER JOIN account_journal pj --- journal 
    ON pj.id = pel.journal_id
WHERE ie.move_type = 'out_invoice'
AND iel.analytic_account_id = 2443
AND ie.name = 'INV/2021/2344'
ORDER BY ie.name