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 <robjsarg...@gmail.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
publickey - nicolas@seinlet.com - 0xCAEB7FAF.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
