This content has been marked as final. Show 2 replies
We would like to get users' job name and the result should give us jobname 'NoJob' unless the user has not job name How could we do that in qlickview.
|SELECT||Users.ID,Users.Name,isnull(JobName,'NoJob') as JobName'|
|FROM||Users LEFT OUTER JOIN|
|UsersJob ON Users.ID = UsersJob.UserID|