17,086
社区成员
发帖
与我相关
我的任务
分享
create table erp_product_info_20110315_tmp
(
PRODUCT_NO VARCHAR2(20) not null,
COLOR_ID VARCHAR2(100) not null,
PRODUCT_SIZE VARCHAR2(100) not null
);
create table pos_product_info_20110315_tmp
(
PRODUCT_NO VARCHAR2(20) not null,
COLOR_ID VARCHAR2(100) not null,
PRODUCT_SIZE VARCHAR2(100) not null
);
select * from pos_tmp a where not exists(
select 1 from erp_tmp b
where a.product_no=b.product_no and a.color_id=b.color_id
and a.product_size=b.product_size)