select a.bh,a.je,a.cd,b.cj,b.cjje from tableA a inner join tableB b on a.bh=b.bh
IF OBJECT_ID('A')IS NOT NULL DROP TABLE dbo.A GO create table A (bh INT,je VARCHAR(4),cd VARCHAR(4) ); insert into A values ('1','2','是'); insert into A values ('2','4','是'); insert into A values ('3','6','是'); IF OBJECT_ID('B')IS NOT NULL DROP TABLE dbo.B GO create table B (bh INT,cj VARCHAR(4),cjje VARCHAR(4) ); insert into B values ('1','1','1'); insert into B values ('2','2','2'); insert into B values ('3','4','4');SELECT A.*,B.cj,B.cjje FROM A LEFT JOIN B ON A.bh=B.bh-------------------- bh je cd cj cjje 1 2 是 1 1 2 4 是 2 2 3 6 是 4 4 --------------------
select count(*) from ( select a.bh,a.je,a.cd,b.cj,b.cjje from tableA a inner join tableB b on a.bh=b.bh ) tab這樣?
create table A (bh int,je int,cd varchar(10)) insert into A (bh,je,cd) select 1,2,'是' union all select 2,4,'是' union all select 3,6,'是' create table B (bh int,je int,cjje int) insert into B (bh,je,cjje) select 1,2,1 union all select 2,4,2 union all select 3,6,4select A.bh,A.je,A.cd,b.cjje from A inner join B on A.bh = B.bh
IF OBJECT_ID('A')IS NOT NULL DROP TABLE dbo.AGOcreate table A (bh INT,je VARCHAR(4),cd VARCHAR(4) );insert into A values ('1','2','是');insert into A values ('2','4','是');insert into A values ('3','6','是'); IF OBJECT_ID('B')IS NOT NULL DROP TABLE dbo.BGOcreate table B (bh INT,cj VARCHAR(4),cjje VARCHAR(4) );insert into B values ('1','1','1');insert into B values ('2','2','2');insert into B values ('3','4','4'); SELECT A.*,B.cj,B.cjje FROM A LEFT JOIN B ON A.bh=B.bh --------------------bh je cd cj cjje1 2 是 1 12 4 是 2 23 6 是 4 4--------------------
select a.bh,a.je,a.cd,b.cj,b.cjje
from tableA a
inner join tableB b on a.bh=b.bh
IF OBJECT_ID('A')IS NOT NULL
DROP TABLE dbo.A
GO
create table A (bh INT,je VARCHAR(4),cd VARCHAR(4) );
insert into A values ('1','2','是');
insert into A values ('2','4','是');
insert into A values ('3','6','是');
IF OBJECT_ID('B')IS NOT NULL
DROP TABLE dbo.B
GO
create table B (bh INT,cj VARCHAR(4),cjje VARCHAR(4) );
insert into B values ('1','1','1');
insert into B values ('2','2','2');
insert into B values ('3','4','4');SELECT A.*,B.cj,B.cjje FROM A LEFT JOIN B ON A.bh=B.bh--------------------
bh je cd cj cjje
1 2 是 1 1
2 4 是 2 2
3 6 是 4 4
--------------------
select count(*) from (
select a.bh,a.je,a.cd,b.cj,b.cjje
from tableA a
inner join tableB b on a.bh=b.bh
) tab這樣?
bh, je,cd,cj,cjje
1 2 是 2 2
2 2 是 1 1
3 3 是 2 2
4 2 是 0 0
查询的结果为
je 数据条数
2 3
2 1
create table A (bh int,je int,cd varchar(10))
insert into A (bh,je,cd)
select 1,2,'是' union all
select 2,4,'是' union all
select 3,6,'是' create table B (bh int,je int,cjje int)
insert into B (bh,je,cjje)
select 1,2,1 union all
select 2,4,2 union all
select 3,6,4select A.bh,A.je,A.cd,b.cjje from A inner join B on A.bh = B.bh