I have a requirement as below.
Table 1 as fields -> Element ID, attribute ID, Text,
Table2 has fields -> Element ID, attribute ID, sequence number, value_for_element,
Now i need to select Element ID and attribute ID, Text fields value from table1 only if there is same element ID and attribute ID value in Table2.
So i wrote a sub/nested query like below which doesn't work.
Select Element ID attribute ID Text,
from table1 as A where ( A.element ID, A.attribute ID ) in ( select distinct Element ID, attribute ID from Table2 )
So basically , i want to compare 2 fields from outer query to inner query and fetch data from outer table.
Please suggest the possible ways to achieve this requirement.
Thanks in advance,