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'
What are the name and payment method of customers who have both mailshots in 'Order' outcome and 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 '
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 = value 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 = value
What are the name and payment method of customers who have both mailshots in 'Order ' outcome and mailshots in 'No Response ' outcome .