5 Replies Latest reply: Dec 31, 2014 7:03 AM by Thomas van Zoggel RSS

    Filtering out null data after join

    Thomas van Zoggel

      Hej guys,

       

      I'm joining three tables in SQL but after doing so I cannot seem to filter out null values in the new table. Even when using the where clause I get one record for each date before 30-12-2014 with null values for every field. I have the following script:


      Temp:
      Load
      Id,
      Run,
      Date(Floor(Timestamp(Run, 'D-M-YYYY h:mm:ss')), 'D-M-YYYY') as Date;
      SQL SELECT Id, Date
      FROM;

      Left Join
      Load
      Id,
      Id2;
      SQL SELECT Distinct Id, Id2
      FROM
      Where Status= 'Done' or Status = 'Finished';

      Left Join
      Load
      Id2,
      Field1,
      Field2,
      Number;
      SQL SELECT Id2, Field1, Field2, Number
      FROM;

      Final:
      Load
      Run&Field1&Field2 as UniqueId,
      Date,
      Field1,
      Field2,
      Number
      Resident Temp
      Where Date >= Date('30-12-2014 0:00:00','D-M-YYYY h:mm:ss');

      Drop Table Temp;