Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
F_Revenue:
Dept,
Revenue,
Service Date
Resident Revenue
Left Join (F_Revenue)
Dept
Active_Begin_Date
Active_End_Date
Resident Dept
WHERE
Thanks,
Steve
Check your manual for INTERVALMATCH, is what you need
Check your manual for INTERVALMATCH, is what you need
Thanks! Steve