Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE order_items ( item_id number, order_item_status_code text, order_id number, product_id number, item_status_code text, item_delivered_datetime time, item_order_quantity text )
TABLE: CREATE TABLE mailshot_customers ( mailshot_id number, customer_id number, outcome_code text, mailshot_customer_date time )
TABLE: CREATE TABLE mailshot_campaigns ( mailshot_id number, product_category text, mailshot_name text, mailshot_start_date time, mailshot_end_date time )
TABLE: CREATE TABLE customer_orders ( order_id number, customer_id number, order_status_code text, shipping_method_code text, order_placed_datetime time, order_delivered_datetime time, order_shipping_charges text )
TABLE: CREATE TABLE products ( product_id number, product_category text, product_name text )
TABLE: CREATE TABLE premises ( premise_id number, premises_type text, premise_details text )
TABLE: CREATE TABLE customer_addresses ( customer_id number, premise_id number, date_address_from time, address_type_code text, date_address_to time )
TABLE: CREATE TABLE customers ( customer_id number, payment_method text, customer_name text, customer_phone text, customer_email text, customer_address text, customer_login text, customer_password text )

### Question ###
Show the name and phone for customers with a mailshot with outcome code 'No Response'.

### Accurate SQL ###

SELECT T1.customer_name, T1.customer_phone FROM customers AS T1 JOIN mailshot_customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.outcome_code = 'No Response'