Re: Constructing a multi-table query

[Rick James]

It's called "JOIN":

SELECT  t.term_id, r.object_id
    FROM  wp_terms AS t
    JOIN  wp_term_relationships AS r ON r.term_taxonomy_id = t.term_id
    WHERE  name = 'blah';