create table A (
ID SMALLINT,
CLIENT VARCHAR(16));
INSERT INTO A VALUES
(1, 'BANK1'),
(2, 'BANK2'),
(4, 'BANK4'),
(6, 'BANK6');
create table B (
ID SMALLINT,
Payments SMALLINT);
INSERT INTO B VALUES
(1, 3000),
(2, 1000),
(3, 2000),
(4, 4000),
(5, 5000);
SELECT A.Client, B.Payments FROM A INNER JOIN B ON A.ID=B.ID;