I have 2 tables "Release" and "Users". In Release, I have a "Created by", "Released by", and "Assigned to" column. They are id number associated to the User table. Currently my set up is this, where if "Release\Assigned to" is equal to "User\ID".

Is there not a better way? This has to crawl the whole User table, and does it 2 other times for Created and Assigned. I thought of filtering the User table, but then I would need to call the SQL connector 3 times in total. Would that be better?