You may jam as many wacky conditions into an ON clause in a JOIN in T-SQL as you might a WHERE clause.

I am used to seeing ON clauses which just match unique ID to unique ID to join tables, but that doesn't mean it has to be that way. You can have two conditions instead of just one.