Hello everyone, I have two DBs and I need to cross them, but I need to be left with a new column that shows those that crossed with a 1 and those that did not with 0. Column 1 1234 2344 456 Column2 0 1 0 thanks

Hi @cmunoq , example is attached. Check it out and if any questions feel free to ask. 2020_06_06_Join_and_Match.knwf (14.9 KB) Br, Ivan

cross two database

cmunoq May 22, 2020, 9:16pm 5

yes sir, in a column that shows me those who crossed with 1 and those who did not cross with 0