Subquery returns more than 1 rowselect building.*,(SELECT import_id from bccondos.condos where bccondos.condos.primary_id_671=les_les.building.primary_id) as import_id from building where directory = 'spectrum-b'