How to join match on closest time?

[finchy]

Hi,

After some advice please.  I am using a left join with Max=0 as need to find some events over a 24 hour period, however a user may have more than one event in the subsearch but i need to match on the closest time to my main search.

Not sure what's the best approach to make that match?

Lee

[ITWhisperer]

This is a rather generic question - as a generic answer, the best approach is to avoid using join if you can.