Captain Obvious

Trying to:

SELECT id FROM table_a WHERE condition='true'
Gets an array of IDs to be used in the next query

SELECT * FROM table_b WHERE id=any of the previous IDs



Whats the best way to do this, can it be done in one query?