Databases are there to be hit, so hit it. You're talking about an optimization with meager benefits and it seems without any justification save for a few charactors in your SQL statement. Your join is the correct way to do it.