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

    Calculating Across Tables

    Phil Speight



      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?