I tried the JOIN query separately and received the output that I needed but when I added it to the existing query, it failed.

I guess what I'm trying to ask is do I need to setup PK and FK? If yes do I create the FK from table1, set the PK table to be table2 pointing to StatusName column and FK table to be table1 pointing to StatusID column?

Thank You