Direct Discovery with SQL joins

sifatnabil — Tue, 24 Feb 2015 02:12:52 GMT

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.

topic Direct Discovery with SQL joins in QlikView