Hello, I'm trying to compare two dates from two inline views in my where clause.
Both of the selects in my views work correctly, these fields are dates.
I want to verify that avail.period is before the date alloc_end.alloc_end from another inlline.
avail.period <= alloc_end.alloc_end AND.....
Thanks in advance, this simple issue is killing me.