So it appears that the issue was not with the SQL. Instead, it was with the Java POJO that I had created as an @Entity. I was using @OneToOne for the foreign key reference and even though all the names were the same it was saying it could not find the column. Changing the @OneToOne to just an @Column fixed the error. The database still holds the key relationship. Everything I read stated what I had should work but it did not. At least I am able to move forward.