for [KW_FOR] @613:22
each [KW_EACH] @613:26
record phrase [RECORD_PHRASE] @0:0
b-res2 [BUFFER] @613:31
where [KW_WHERE] @613:38
expression [EXPRESSION] @0:0
and [KW_AND] @613:76
>= [GTE] @613:59
b-res2.checkin [FIELD_DATE] @613:44
b-res.checkin [FIELD_DATE] @613:62
<= [LTE] @613:95
b-res2.checkin [FIELD_DATE] @613:80
b-res.checkout [FIELD_DATE] @613:98
no-lock [KW_NO_LOCK] @613:113
each [KW_EACH] @614:25
record phrase [RECORD_PHRASE] @0:0
b-out-room2 [BUFFER] @614:30
where [KW_WHERE] @615:28
expression [EXPRESSION] @0:0
and [KW_AND] @616:79
and [KW_AND] @615:74
<> [NOT_EQ] @615:53
recid [FUNC_RECID] @615:34
b-out-room2 [BUFFER] @615:40
recid [FUNC_RECID] @615:56
b-out-room [BUFFER] @615:62
= [EQUALS] @616:58
b-out-room2.room-number [FIELD_INT] @616:34
b-room.room-number [FIELD_INT] @616:60
= [EQUALS] @617:61
b-out-room2.reservation-id [FIELD_INT] @617:34
b-res2.reservation-id [FIELD_INT] @617:63
no-lock [KW_NO_LOCK] @618:25
|