 <p>Are you looking for mere joins? Put your two queries in your <code>FROM</code> clause and join them on <code>customer_id</code>, then join with the <code>customers</code> table and show the results.</p> <pre><code>select c.id as customer_id, c.first_name, c.last_name, c.preferred, period1.label_cost as period1_label_cost, period2.label_cost as period2_label_cost from ( select customer_id, sum(total_cost) as label_cost from orders where date(created_at) between &lt;start_date1&gt; and &lt;end_date1&gt; group by customer_id having sum(total_cost) &gt; &lt;sales_exceeded&gt; ) period1 join ( select customer_id, sum(total_cost) as label_cost from orders where date(created_at) between &lt;start_date2&gt; and &lt;end_date2&gt; group by customer_id having sum(total_cost) &lt; &lt;sales_below&gt; ) period2 on period2.customer_id = period1.customer_id join customers c on c.id = period1.customer_id; </code></pre>