oracle sql compare result two subselects

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,, po.art_id, po.quantity, po.price FROM INV_HEAD he join INV_POS po on po.he_id =

Now I want to find invoices with the same positions, not necessarily in the same order. How can I do this?

Source: oracle

Leave a Reply