This seems simple, but it keeps tricking me. Could not get the proper
result. Thanks in advance!
TABLE1
App_ID Business_Unit_ID PROFILE_ID
1 001 AA1
3 001 AA1
TABLE2 - SUPERSET
App_ID Business_unit_ID
1 001
1 002
1 003
1 007
2 002
2 003
3 001
3 002
3 007
4 009
4 008
USING Business_Unit_ID and App_ID in TABLE1,
check to see if App_ID & Business_Unit_ID is in table2
if app_id and Business_Unit_Id from table1 is found in table2 (or is a
sub-set in table2) then
retun true
else false
In this example, the result should be True