What are all the cross reference codes?
select source_system_code from cmi_cross_references group by source_system_code
Show me the cross references with code as Tax.
select * from cmi_cross_references where source_system_code = 'Tax'
What are the details of the cmi masters of them?
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'