Direct Discovery with SQL joins

[sifatnabil]

Hi, I have this MS SQL query with joins, but applying the Direct Discovery syntax causes an error:

DIRECT QUERY sb.Name,sso.*  from LFEControlFusion..ServiceBrokerrole sbr

left join LFEControlFusion..servicebroker sb

on sb.servicebrokerId = sbr.servicebrokerId

left join LFEControlFusion..aspnet_users au

on sbr.userId = au.userid

inner join Fusion..ssosessionconnections sso

on sso.Username = au.UserName

where sbr.UserId is not null;

Am I using the right syntax? I am using the latest version of Qlikview.