5 Replies Latest reply: Aug 25, 2015 4:31 AM by Kim Burata RSS

    Join Problem

    Kim Burata

      Hi all,

       

      How would you do this T-SQL statement to QlikView?

       

      SELECT

           A.Key1,

           B.Key1,

           A.Data1,

           A.Data2,

           B.Data3

      FROM A

      LEFT JOIN B

      ON A.Key1=B.Key1

       

      I am particularly after how to display A.Key1 and B.Key1 which I can do in T- SQL

       

      Thanks