Join whitout direct relationship

[Anonymous]

hi, i need help with this case:

i have two tables linked by link table like this: 

now I want to add columns from the "AC_CONTACTOS" table to the "AC_GANADOS" table using email as a key, (similar to SQL's left join) but I haven't been able to, because there is no direct relationship between the two tables.

Does anyone have any idea how to do it?

[Anonymous]

So, it looks like in fact the connection from the one-side table to the many-side table (AC_Contactos) is 1 to 1? If there is more than 1 row in AC_Contactos for one row in the one-side table, how do you want to handle this?

[wdx223_Daniel]

maybe LOOKUPVALUE can help

[amitchandak]

@Anonymous , You have to bring it to the table having email and then move in from there to another table. 2 steps.

Refer to this video for the option to copy .: https://youtu.be/czNHt7UXIe8