4 Replies Latest reply: Aug 9, 2016 6:22 PM by Massimo Grossi RSS

    Inner Join in Load SQL Load Statement

    Emma Green

      Hi All,

       

      I'm am running into some trouble with my inner join statement. I am bringing in the correct number of observations from 'Table 1' but when inner joining using syntax below, Qlik is bringing in all records from the other tables, not only where the tables are mutual...

       

      Suggestions? Thank you!

       

       

      SQL SELECT ITMSNumber,Prioritization,SCA,DATALOADSTATUSID, LOADPRIORITYSTATUSID
      FROM MPL.dbo.tblSTRATEGY
      where loadprioritystatusid=20 or loadprioritystatusid=30 or loadprioritystatusid=100;

      Inner Join(Table1)
      SQL SELECT *
      FROM MPL.dbo.tblAPPINVENTORY;

      Inner Join(Table1)
      SQL SELECT Acronym,
      ITMSNumber,
      Name
      FROM MPL.dbo.tblBASIC;