Hello
Thanks for all your previous answers. |
If the answers solve your question, please say a word in each topic to thank other users/developers, so we know you have fit your questions.
what is it different from "First"? |
I show a use case to explain your question,eg:
main:
id;name
1;shong
2;plegall
lookup:
id;age
1;11
1;12
1;13
2;21
3;31
Do a inner join with id key and output id,age column.
"Unique" and "Last match" have same behavior, get:
1;13
first match, get:
1;11
all match, get:
1;11
1;12
1;13
Best regards
shong