Hi,
I would kindly ask for help on this matter. Let me explain, we have 2 tables:
USER_TABLE
USER | POSITION | PRODUCT |
---|
USER1 | 1 | 55 |
USER2 | 2 | 56 |
USER2 | 1 | 55 |
USER1 | 2 | 56 |
USER1 | 3 | 57 |
USER2 | 10 | 57 |
And DEFAULT_USER table
I need to extract only USER from USER_TABLE where match is on USER_TABLE.POSITION = DEFAULT_USER.POSITION and USER_TABLE.PRODUCT = DEFAULT_USER.PRODUCT, meaning from the example above, result would be only USER1 as USER2 fails for product 57.
Thanks !