what are the details of the cmi masters that have the cross reference code 'Tax'?
create table cmi_cross_references (master_customer_id varchar, source_system_code varchar, PRIMARY KEY (master_customer_id)); create table customer_master_index (cmi_details varchar, master_customer_id varchar, PRIMARY KEY (cmi_details))
select t1.cmi_details from customer_master_index as t1 join cmi_cross_references as t2 on t1.master_customer_id = t2.master_customer_id where t2.source_system_code = 'tax'