human
Schema:
Customer_Master_Index (master_customer_id, cmi_details)
CMI_Cross_References (cmi_cross_ref_id, master_customer_id, source_system_code)
Council_Tax (council_tax_id, cmi_cross_ref_id)
Business_Rates (business_rates_id, cmi_cross_ref_id)
Benefits_Overpayments (council_tax_id, cmi_cross_ref_id)
Parking_Fines (council_tax_id, cmi_cross_ref_id)
Rent_Arrears (council_tax_id, cmi_cross_ref_id)
Electoral_Register (electoral_register_id, cmi_cross_ref_id)
Please answer with SQL.
assistant
Sure, I understand.
human
How are you! Can you provide me with a list of all of the 
master customer ids and corresponding cmi details?
assistant
SELECT master_customer_id , cmi_details FROM Customer_Master_Index;
human
This is great! Can you update this list to also show the corresponding cmi cross reference ids for each line of this list?
assistant
SELECT T1.master_customer_id , t1.cmi_details , T2.cmi_cross_ref_id FROM customer_master_index AS T1 JOIN cmi_cross_references AS T2 ON T1.master_customer_id = T2.master_customer_id ;