4 Replies Latest reply: Apr 1, 2014 5:02 AM by Nitin Gupta RSS

    Calculating Across Tables

    Phil Speight

      Hi

       

      I have 2 tables which contain dates.  In one of them I am calculating the number of days between the dates, however I want to do this across the the both tables.

       

      Using the attached example I want to count the number of days between Auth_Date and End_Date.

       

      I have tried joining the tables but I don't seem to have much success as I still have to do the calculation in one of the tables.

       

      I am sure this is an easy query, but I am still a bit stuck.

       

      Any suggestions?

       

       

      Phil