CREATE TABLE A (a_id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE B (a_id INTEGER UNIQUE REFERENCES A(a_id), count INTEGER);

SELECT B.a_id
FROM A
JOIN B b ON b.a_id = A.a_id;