Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM in_inventory_item A
- INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
- WHERE A.product_id BETWEEN 6838 AND 6841;
- SELECT C.journal_trx_id, *
- FROM in_inventory_item A
- INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
- INNER JOIN gl_journal_trx C ON B.inventory_id = C.doc_id AND B.doc_type_id = C.doc_type_id
- WHERE A.product_id BETWEEN 6838 AND 6841;
- SELECT D.journal_trx_item_id, *
- FROM in_inventory_item A
- INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
- INNER JOIN gl_journal_trx C ON B.inventory_id = C.doc_id AND B.doc_type_id = C.doc_type_id
- INNER JOIN gl_journal_trx_item D ON D.journal_trx_id = C.journal_trx_id AND A.inventory_item_id = D.ref_id
- WHERE A.product_id BETWEEN 6838 AND 6841;
- DELETE FROM gl_journal_trx_item WHERE journal_trx_item_id IN (16693063, 15960233, 15960232, 15960231, 15960230)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement