CREATE CURSOR source ( order N(1), text1 C(5))

INSERT INTO source (order, text1) VALUES ( 1, '123')
INSERT INTO source (order, text1) VALUES ( 2, '234')
INSERT INTO source (order, text1) VALUES ( 3, '45678')
INSERT INTO source (order, text1) VALUES ( 4, '8')

CREATE CURSOR dict ( text2 C(10), value N(8), dict_no n(1))

INSERT INTO dict (text2, value, dict_no) VALUES ( '123', 123, 1)
INSERT INTO dict (text2, value, dict_no) VALUES ( '234', 234, 1)
INSERT INTO dict (text2, value, dict_no) VALUES ( '45678', 45678, 1)
INSERT INTO dict (text2, value, dict_no) VALUES ( '456789', 456789, 1)
INSERT INTO dict (text2, value, dict_no) VALUES ( '4', 4, 1)
INSERT INTO dict (text2, value, dict_no) VALUES ( '9', 9, 1)

SET ANSI On

SELECT order, text1, text2, value FROM source;
    LEFT JOIN dict ON text1=text2
    
SELECT order, text1, text2, value FROM source;
    LEFT JOIN dict ON text1=text2;
    WHERE dict_no=1

SELECT order, text1, text2, value, dict_no FROM source;
    LEFT JOIN dict ON text1=text2