Re: More records after sort

Thanks all, I'll try this on Monday when I go back to the office.

Nicolas.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Wednesday, July 21st, 2021 at 02:55, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

> > Query:
> >

> > INSERT INTO invl_aml_mapping_temp(invl_id, aml_id, cond)
> >

> >                SELECT il.id, ml.id, 48
> >

> >                    FROM account_invoice_line il
> >

> >                    JOIN account_invoice i ON i.id = il.invoice_id
> >

> >                    JOIN account_move m ON m.id = i.move_id
> >

> >                    JOIN account_move_line ml ON ml.move_id = m.id
> >

> >                    JOIN res_company comp ON comp.id = i.company_id
> >

> >                WHERE il.display_type IS NULL
> >

> >                  AND ml.tax_line_id IS NULL
> >

> >                  AND NOT EXISTS (SELECT invl_id FROM invl_aml_mapping WHERE invl_id=il.id)
> >

> >                  AND NOT EXISTS (SELECT aml_id FROM invl_aml_mapping WHERE aml_id=ml.id)
> >

> >                  AND i.id = 
>

> Out of curiosity, would combining those two NOT EXISTS in one help? Ever? 
>

> > i.e. WHERE invl_id=il.id or aml_id = ml.id