What is the tax source system code for benefits and overpayments?
select t1.source_system_code from cmi_cross_references as t1 join benefits_overpayments as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id
List benefit ID, please.
select t1.source_system_code, t2.council_tax_id from cmi_cross_references as t1 join benefits_overpayments as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id
Order them by benefit ID, Please.
select t1.source_system_code, t2.council_tax_id from cmi_cross_references as t1 join benefits_overpayments as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id order by t2.council_tax_id
Ok, can you show me the list of the source system codes?
select source_system_code from cmi_cross_references