2 Replies Latest reply on Oct 27, 2015 12:22 AM by rp0428

    Sub queries (cannot make a table or use delete statement)

    d2edea74-b510-4aa0-ad73-e3f72b6f45c8

      I am trying to write a syntax where I eliminate Nulls fore example

       

      Person 1 & 3 will not show up since in one of their accts are nulls.

      Any help will be much appreciated.

        

      PersonAcct#$
      1410
      15Null
      2610
      2715
      3815
      3320
      310Null
      4115
      4123
      4138
      41410
      Desired Result
      Person$
      225
      426