$wpdb: how to use a query as a base for another query?

$wpdb: how to use a query as a base for another query?