测试内容:
[code]
create table A(
A1 VARCHAR(16)
);
create table B(
B1 VARCHAR(16)
);
insert into A(A1) values('content_1');
insert into A(A1) values('content_2');
insert into A(A1) values('content_3');
insert into B(B1) values('content_4');
-- 测试 --
select count(*) from A where A1 in (select A1 from B);
-- 表B中并不存在A1字段 --
[/code]
输出结果:
3
[code]
create table A(
A1 VARCHAR(16)
);
create table B(
B1 VARCHAR(16)
);
insert into A(A1) values('content_1');
insert into A(A1) values('content_2');
insert into A(A1) values('content_3');
insert into B(B1) values('content_4');
-- 测试 --
select count(*) from A where A1 in (select A1 from B);
-- 表B中并不存在A1字段 --
[/code]
输出结果:
3