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.