Ever have one of those problems that you just *know* could be solved in one very clever (and not overly complicated) SQL statement? Ever realize you're just not seeing it and as a result trying to write a ton of code to do the same thing?

I know there's a join of some sort that would make this data transfer thing pretty darn simple to do. I just can't see it right now. Guess I know what i'll be dreaming about tonight...