MySQL 5.7

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

CREATE TABLE `Table 1`
    (`ID` varchar(3), `Name` varchar(5), `Salary` int)
;
    
INSERT INTO `Table 1`
    (`ID`, `Name`, `Salary`)
VALUES
    (123, 'Mike', 5000),
    (129, 'David', 4000),
    (133, 'Linda', 4500)
;


CREATE TABLE `Table 2`
    (`ID` varchar(4), `Dept` varchar(12))
;
    
INSERT INTO `Table 2`
    (`ID`, `Dept`)
VALUES
    (0123, 'IT'),
    (0129, 'Tech Support'),
    (0133, 'Analytics')
;
SELECT t1.ID, t1.Name, t2.Dept
FROM `Table 1` t1
JOIN `Table 2` t2 ON t2.ID % 1000 = t1.ID


ID
Name
Dept


123
Mike
IT

129
David
Tech Support

133
Linda
Analytics