how to select all b2bcustomers through the certain usergroup?

[former_member647104]

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 table ??? }} WHERE {bc:group} = 'b2bcustomer'

[former_member620692 · Accepted solution]

The following query will give you all the users belonging to 'admingroup'. You can customize this as per your requirement:

 SELECT {u:uid}, {ug:uid} FROM
 {
    UserGroup as ug JOIN PrincipalGroupRelation as rel
    ON {ug:PK} = {rel:target}
    JOIN User AS u
    ON {rel:source} = {u:PK}
 }
 WHERE {ug:uid}='admingroup'

[former_member647104 · Accepted solution]

Big thanks, that is what I'm looking for.

[former_member620692 · Accepted solution]

You are most welcome.