How are you!  Can you provide me with a list of all of the 
master customer ids and corresponding cmi details?
select master_customer_id, cmi_details from customer_master_index
This is great!  Can you update this list to also show the corresponding  cmi cross reference ids for each line of this list?
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
Can you filter this list so that the only rows that are displayed are those containing "Gottlieb, Becker and Wyman"?
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 where t1.cmi_details = 'Gottlieb, becker and Wyman'