Yes
select t2.customer_name from mailshot_customers as t1 join customers as t2 on t1.customer_id = t2.customer_id where t1.outcome_code = 'Order'
What are the payment methods of those customers?
select t2.payment_method from mailshot_customers as t1 join customers as t2 on t1.customer_id = t2.customer_id where t1.outcome_code = 'Order'
Show me names and payment methods of customers who have mailshot with an outcome code "No Response"
select t2.customer_name, t2.payment_method from mailshot_customers as t1 join customers as t2 on t1.customer_id = t2.customer_id where t1.outcome_code = 'No Response'