I have a serach which will gives the Top 4 records.
Search1 result looks like
I have one another search which gives the result like:
Search2 result looks like:
How can I get the below result using the 2 searches above (Only those rows from Search2 whose Col-1 value is present in Search1 Col-1)?
Expected Final Result Table
Please guide/help me.