Couple of things to be aware of IME
JOINing on a concatenated string will run like a dog If the number of rows you have is small it won't be a problem ... unless the number of rows will grow/scale (over time).
Its fragile. Are the names really maintained absolutely identically in both tables? No ambiguity with "John Smith" etc?
I always prefer to see some sort of ID in these cases, so that the Name itself is not the key. Typos get fixed, People change name on marriage and so on ... all sorts of pitfalls.
Hopefully none of that applies in your case, but just thought I'd raise it ... just in case