Show the name for customers.
select customer_name from customers
Also show their payment methods.
select customer_name, payment_method from customers
How about the results for those haing mailshots in 'Order' outcome
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 = 'Order'
What about those also having mailshots in 'No Response' outcome?
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 = 'Order' intersect 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'