1, the problem is: the query asks for leave the user name in the table, the database for start time and end time and create time, it is according to create time to check from month to month number one
End, leave time is according to the day to check,

2, now is the time to create needs between the and check for the month, with creation time whether to ask for leave in the between and within the scope of the

3, now need to consult the creation time during the month, and then take to create in the between the and check in time to ask for leave interval,

So, whether to use sub queries or what, how can you use out, or have other ideas query, also want to help out,

CodePudding user response:

Table structure, test data, expected results...