Task: Text to Code
Input (English): SQL: SELECT source_system_code , master_customer_id FROM CMI_Cross_References
Feedback: Make sure to find each value related to cmi cross reference id of parking fines table .
Output (English): 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