SQL的查询JOIN
create table t1
(
[id] int identity(1,1) primary key,
Cargo char(1),
CargoNumber char(1),
InStockNumber int
)
insert into t1 values('A','B',10)
insert into t1 values('A','C',10)
insert into t1 values('A','D',10)
-------------------------------------------
create table t2
(
[id] int foreign key references t1([id]),
opDate datetime,
opNumber int
)
insert into t2 values(1,'2005-1-1',7)
insert into t2 values(2,'2005-1-1',3)
insert into t2 values(2,'2005-1-1',2)
insert into t2 values(2,'2005-1-1',4)
select a.cargo,a.cargonumber,a.instocknumber,b.opDate,b.opNumber
from t1 as a inner join t2 as b on (a.[id] = b.[id])
我希望的结果是
第3,第4行的A,C由于已经在显示过了,所以不要再显示出来