Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Join whitout direct relationship

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?

join
SQL

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?