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 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?


Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.