The spec isn't entirely clear; does this generate the results you're expecting to see?
SELECT b.*, a.*, x.*
FROM TableB b
LEFT JOIN TableA a ON b.ColId = a.Area
LEFT JOIN TableA x ON x.Area IS NULL AND a.Area IS NULL
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden