now I have more than three tables need more condition LianZha table, table structure as
, the query conditions: 
don't know this, I hope to have a bosses guidance should be how to write, my idea is to check whether the department first, if is performed under one condition, see what position, ask for leave if low position in the query table, have without leave, the final judgment time even, if late for more than 8.25 if!!!!!!!!!! And if not this department will direct release, high position grade will be directly released, will direct release work normal work 
, CodePudding user response:
I think this question, still stays on the level of demand, throw to the developer, a bit difficult,CodePudding user response:
Upstairs positive solution, if throw experienced development of course know how to dismantle the demand, if it is a new people forget it,