Trying to combine one row from one table with mulitple rows from another table but not sure if I'm doing it right?
It's not the only way to do it, but the other solutions won't perform any better.  You could create a function and use that for the values of your column, which might make your query easier to read.  But it won't perform better and depending on your scale, it may perform quite a bit worse.