[MySql] Union Query

Sample

CREATE TABLE `union_test_a` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    `item_number`  varchar(25)        NOT NULL                COMMENT '상품번호',
    `ranking`      varchar(2)         NOT NULL DEFAULT '1'    COMMENT '우선순위',
    PRIMARY KEY (`id`),
    KEY `idx_sch_edlp` (`item_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TEST_A';


CREATE TABLE `union_test_b` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    `item_no`   varchar(25)        NOT NULL                COMMENT '상품번호',
    `ranking`   varchar(2)         NOT NULL DEFAULT '1'    COMMENT '우선순위',
    PRIMARY KEY (`id`),
    KEY `idx_sch_edlp` (`item_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TEST_B';

INSERT INTO `doo`.`union_test_a` (`item_number`, `ranking`) VALUES ('292939882','1');
INSERT INTO `doo`.`union_test_a` (`item_number`, `ranking`) VALUES ('123334234','2');
INSERT INTO `doo`.`union_test_a` (`item_number`, `ranking`) VALUES ('675866456','3');
INSERT INTO `doo`.`union_test_b` (`item_no`, `ranking`) VALUES ('986756745','4');
INSERT INTO `doo`.`union_test_b` (`item_no`, `ranking`) VALUES ('196456435','5');
INSERT INTO `doo`.`union_test_b` (`item_no`, `ranking`) VALUES ('454345235','6');
INSERT INTO `doo`.`union_test_b` (`item_no`, `ranking`) VALUES ('856456456','7');

SELECT item_number FROM doo.union_test_a
 union 
SELECT item_no as item_number FROM doo.union_test_b;

-- 중복허용
SELECT item_number FROM doo.union_test_a
 union all
SELECT item_no as item_number FROM doo.union_test_b;