conditional.sql

INSERT INTO `copy_db_broker`.`order` (
    SELECT *
    FROM `original_db`.`order`
    WHERE `original_db`.`order`.`broker_name` = `customer_broker_name`
    AND `original_db`.`order`.`id` NOT IN (
        SELECT `id`
        FROM `copy_db_broker`.`order`
    )
)