Wat is the tax source system code and master customer id of the taxes related to each parking fine id?
create table cmi_cross_references (source_system_code varchar, master_customer_id varchar, cmi_cross_ref_id varchar, PRIMARY KEY (source_system_code)); create table parking_fines (council_tax_id varchar, cmi_cross_ref_id varchar, PRIMARY KEY (council_tax_id))
select t1.source_system_code, t1.master_customer_id, t2.council_tax_id from cmi_cross_references as t1 join parking_fines as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id