Hi
I have a serach which will gives the Top 4 records.
Example
Search1 result looks like
Col-1
ABC
DEF
GHI
JKL
I have one another search which gives the result like:
Search2 result looks like:
Col-1 Col-2
ABC 123
DEF 456
GHI 789
ABC 101
JKL 112
MNO 131
PQR 415
STU 161
VWX 718
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
Col-1 Col-2
ABC 123
DEF 456
GHI 789
ABC 101
JKL 112
Please guide/help me.
... View more