表A:
column1 column2
1 A
2 B表B:
column1 column2
1 C
1 D
2 E
2 F表C:
column1 column2
A C
A D
B E表C應還有一條記錄為
column1 column2
B F求如何用sql語句查詢此記錄?
column1 column2
1 A
2 B表B:
column1 column2
1 C
1 D
2 E
2 F表C:
column1 column2
A C
A D
B E表C應還有一條記錄為
column1 column2
B F求如何用sql語句查詢此記錄?
insert into @A select '1','A'
insert into @A select '2','B'declare @B table(column1 varchar(8),column2 varchar(8))
insert into @B select '1','C'
insert into @B select '1','D'
insert into @B select '2','E'
insert into @B select '2','F'declare @C table(column1 varchar(8),column2 varchar(8))
insert into @C select 'A','C'
insert into @C select 'A','D'
insert into @C select 'B','E'select a.column2,b.column2
from @A a inner join @B b
on a.column1=b.column1
left join @C c
on a.column2=c.column1 and b.column2=c.column2
where c.column1 is null--结果
column2 column2
-------- --------
B F(所影响的行数为 1 行)
select 1,'a' union
select 2,'b' insert b (column1 , column2)
select 1,'c' union
select 1,'d' union
select 2,'e' union
select 2,'f'
节下来一样写