3 Replies Latest reply: Feb 22, 2017 1:58 PM by Massimo Grossi RSS

    Script Help

    Mark Ritter

      I don't know if this is possible or even makes sense to do.


      But here goes.


      I want to create one table that contains all terminated employees and a second table that contains all active employees.  I have done that so far.


      Now the part I am not sure of.


      I want to create a third table that contains all of the terminated employees and only the active employees where there is no matching employee id in the terminated table.


      So far I have something like this:


      Load Distinct Employee_ID

      From QVD where currentactive='0'




      Load Distinct Employee_ID

      From QVD where currentactive='1'


      Next I want to combine them into a third table as I detailed above.


      Not sure how to do that.