What are the register ids of electoral registries that have the cross reference source system code 'Electoral' or 'Tax'?
create table electoral_register (electoral_register_id varchar, cmi_cross_ref_id varchar, PRIMARY KEY (electoral_register_id)); create table cmi_cross_references (cmi_cross_ref_id varchar, source_system_code varchar, PRIMARY KEY (cmi_cross_ref_id))
select t1.electoral_register_id from electoral_register as t1 join cmi_cross_references as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id where t2.source_system_code = 'electoral' or t2.source_system_code = 'tax'