This content has been marked as final. Show 2 replies
I need to left join the F_Revenue table to the Dept_Activation table by the Dept field AND where the Service Date on the F_Revenue table is between the Active_Begin_Date and Active_End_Date. Looking for help on how to code the where clause to make this happen?
Left Join (F_Revenue)