I need some help to solve the follwing problem:
I have to sort out hospital inpatients who have been in more than once in a given period, listing those periods.
Here is the syntax that works, BUT how can I solve the problem of having to input the dates (date1 & date2) twice??
select .....
from...