8 Replies Latest reply: May 18, 2015 10:02 AM by Peter Hargreaves RSS

    Joining multiple SQL selects into one

      Hello

      I've got problem with SQL selects - I've got 4 selects, but Qlik loads only first one. I've tried putting joins between them, but none worked yet.

       

      My code looks like this:

       

      Data:

      SQL SELECT * FROM QV_FAB_1(201501);

      LEFT JOIN (Data)

      SQL SELECT * FROM  QV_FAB_2(201501);

      LEFT JOIN (Data)

      SQL SELECT * FROM  QV_FAB_3(201501);

      JOIN

      SQL SELECT * FROM  QV_FAB_4;

       

      I tried doing something like this:

      Data:

      SQL SELECT * FROM QV_FAB_1(201501);

      Data2:

      SQL SELECT * FROM  QV_FAB_2(201501);

       

      And it wasn't working.

       

      My final target is to get this SQL tables and write them into .qvd, it works but only for first select, columns from 2, 3, and 4 don't exist in Qlik.