2 Replies Latest reply: Jan 9, 2013 8:21 AM by Lav Jain RSS

    Left inner join and get only null rows

      Hi,

       

      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.

       

      Thanks

       

      Users 

      ID
      Name
      1Alan
      2Jack
      3Aly

       

       

      UsersJob

      ID
      UserId
      JobName
      11lkjlklj
      23sdfsdfsdf

       

       

      SELECT    Users.ID,Users.Name,isnull(JobName,'NoJob') as JobName'
      FROM        Users LEFT OUTER JOIN
                           UsersJob ON Users.ID = UsersJob.UserID