a_id    |    a_meter    |    a_city
1        |    24             |    Moscow
2        |    26             |    Penza

b_id   |   b_meter |   b_number     |    b_time
1       |   24          |   111               |    2016-02-01 23:48:00.000
2       |   26          |   222               |    2016-02-01 23:48:00.000  
3       |   24          |   333               |    2017-22-09 23:48:00.000

24    |   Moscow   |   333
26    |   Penza      |   222

SELECT TableA.a_meter, TableA.a_city, TableB.b_number
FROM TableA
INNER JOIN TableB ON TableA.a_meter = TableB.b_meter

DROP TABLE TableA ;
DROP TABLE TableB ;

CREATE TABLE TableA (
  a_id INT NOT NULL,
  a_meter VARCHAR(50),
  a_city NVARCHAR(128),
  PRIMARY KEY (a_id));
    
CREATE TABLE TableB (
  b_id INT NOT NULL,
  b_meter VARCHAR(50),
  b_number VARCHAR(50),
  b_time DATETIME,
  PRIMARY KEY (b_id));
  
INSERT INTO TableA VALUES (1, 24, 'Moscow') ;
INSERT INTO TableA VALUES (2, 26, 'Penza') ;
INSERT INTO TableB VALUES (1, 24, 111, '2016-02-01 23:48:00.000') ;
INSERT INTO TableB VALUES (2, 26, 222, '2016-02-01 23:48:00.000') ;
INSERT INTO TableB VALUES (3, 24, 333, '2017-02-09 23:48:00.000') ;