It's a fundamental feature of Qlik that equally named fields associate the tables - complete independently in which relation those key-fields are. So you might need to build your datamodel different whereby thinking in SQL logics are rather not helpful.
