SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT '5WWW55' account_num,        'John' Name INTO Table_A
UNION ALL
SELECT 'DDDDD7',        'Jacob' UNION ALL
SELECT 'SSSSX7',        'jingleheimer'
3 rows affected

SELECT   '5WWW55' account_num,        'John' Name INTO Table_B
UNION ALL
SELECT '3SSSX7',        'jingleheimer'
2 rows affected

SELECT Table_B.*, Table_A.*,
       DIFFERENCE(Table_A.account_num , Table_B.account_num) AS diff
FROM Table_A
JOIN TABLE_B 
  ON DIFFERENCE(Table_A.account_num , Table_B.account_num) = 4


account_num
Name
account_num
Name
diff


5WWW55
John
5WWW55
John
4

3SSSX7
jingleheimer
5WWW55
John
4