If your business uses relational databases to store data, it helps to use the SQL ... table FROM old_table_a WHERE address NOT LIKE '%Los Angeles%' UNION SELECT last_name, address FROM old_table_b ...