系统表A 有字段 number 1
2
系统表B 有字段 keynumber user 1 u1
1 u2
2 u1keynumner对应A表的number.我想得到user为“u1”..对应在A表的记录则是显示A表记录1和2如果user为“u2”..对应在A表的记录则是显示A表记录1
2
系统表B 有字段 keynumber user 1 u1
1 u2
2 u1keynumner对应A表的number.我想得到user为“u1”..对应在A表的记录则是显示A表记录1和2如果user为“u2”..对应在A表的记录则是显示A表记录1
declare @A table(id int)
insert @A select 1
union all select 2
declare @B table(id int,S_USER varchar(20))
insert @B select 1,'u1'
union all select 1,'u2'
union all select 2,'u1'
--查看测试数据
select * from @A
select * from @B
union all select 2
create table b ( keynumber int, usre varchar(10))insert into b select 1, 'u1'
union all select 1, 'u2'
union all select 2, 'u1'结果:select number from a right join b on a.number=b.keynumber where b.usre='u2'
查询结果
------
1
select number from a right join b on a.number=b.keynumber where b.usre='u1'
查询结果
---------
1
2
insert @A select 1
union all select 2
declare @B table(id int,S_USER varchar(20))
insert @B select 1,'u1'
union all select 1,'u2'
union all select 2,'u1'declare @user varchar(20)
set @user='u1'
select a.* from @a a,@b b where a.id=b.id and s_user=@user
2 gg
系统表B 有字段 keynumber user 1 u1
1 u2
2 u1keynumner对应A表的number.我想得到user为“u1”..对应在A表的记录则是显示A表记录mm和gg如果user为“u2”..对应在A表的记录则是显示A表记录gg
是这样吗?