Let’s say I have two Oracle SQL tables for my invoices. INV_HEAD for adress, date, …
Then I have INV_POS for every position of the invoice.
I can list all the invoices with
SELECT he.id, he.date, po.art_id, po.quantity, po.price FROM INV_HEAD he join INV_POS po on po.he_id = he.id
Now I want to find invoices with the same positions, not necessarily in the same order. How can I do this?