3 Replies Latest reply: Aug 11, 2017 4:45 AM by Arpit Kharkia RSS

    Comparison of dates while doing resident load

    Arpit Kharkia

      Hi all,

       

      I have two tables. Consider the following example.

       

      TableA:

      Load     ID,

                   DateA,

                     ColA,

                     ColB

      From ...;

       

      Left join(TableA)

       

      TableB:

      Load     ID,

                   DateB

      From ...;

       

      I want a final table where DateA is greater that DateB. Im tring the following:

       

      TableC:

      Load *

      Resident TableA where (DateA-DateB)>0

       

       

      Please note there are some tables being left joined to Table A before left joining TableA and TableB

       

      Help appreciated!