For example: SELECT {bc:name} FROM {b2bcustomer AS bc LEFT JOIN usergroup AS ug ON { ??? Here is the question > How to get correct relation? I guess there should be another table with the same key, to relate it with b2bcustomer table and usergroup t...