how to get association data in using database connector

Hi Team, I am using database connector to get data from an external database. In that database I have association with Account To Role-[ Reference Set] How can I get the user role data of a particular account using query? I am using the below query but it does seem to work. The user role association is coming as empty. select as "Email", z.lastlogin as "LastLogin" ,  as "Name"  from  (((Administration$Account account inner join System$user z on inner join System$userroles ur on$userid) inner join System$userrole r on ur.System$ where is not null  
0 answers