<@U3YKR8H2B>, yes, you use aliases the right way, ...
# exposed
t
@tmseiler, yes, you use aliases the right way, but I guess you don't need second alias.
Copy code
val destinationAlias = StopTimes.alias("dest")
    StopTimes.innerJoin(destinationAlias, {trip_id}, {this[StopTimes.trip_id]}).select {
        StopTimes.stop_id eq origin.stop_id and
                destinationAlias[StopTimes.stop_id] eq destination.stop_id and
                StopTimes.stop_sequence less destinationAlias[StopTimes.stop_sequence]    
    }.map { fromRowAlias(it, originAlias) }
👍 1