有两个表,表A和表B
A表中
sfzno(身份证号) yjny(应缴年月)
XXXX 200801
XXXX 200802
XXXX 200803
DDDD 200801B表中sfzno(身份证号) sjny(实缴年月) je(金额)
XXXXX 200801 100
XXXXX 200803 50
DDDDD 200801 120
DDDDD 200802 70
排列号变参成:
sfzno yjny sjny jexxxx 200801 200801 100
xxxx 200802 null null
xxxx 200803 200803 50谢谢,应该怎查询排序呢?
A表中
sfzno(身份证号) yjny(应缴年月)
XXXX 200801
XXXX 200802
XXXX 200803
DDDD 200801B表中sfzno(身份证号) sjny(实缴年月) je(金额)
XXXXX 200801 100
XXXXX 200803 50
DDDDD 200801 120
DDDDD 200802 70
排列号变参成:
sfzno yjny sjny jexxxx 200801 200801 100
xxxx 200802 null null
xxxx 200803 200803 50谢谢,应该怎查询排序呢?
解决方案 »
- 关于表所占空间大小问题
- 如何实现这种数据加密要求?
- 为什么我的查询分析器无法用互联网连另一台互联并装有数据库的机器~~~~~~~~~
- 怎样合并纪录集?
- Win32下如何访问SQL Server?
- inner join的问题
- 服务器: 消息 208,级别 16,状态 1,行 1 请高手解决
- 如何将数据库由拉丁文字符集server导到繁体server中,包括库中所有object和data,最主要是varchar类型data?
- 请问各位,MS SQL SERVER数据库或表有无损坏的情况,如果有,怎样修复?
- 跪求高手帮忙用SQL语句展BOM
- "不自动重新计算统计"是什么意思呀,联机帮助查不到?
- SQL??
from a left join b
on a.sfzno = b.sfzno and a.yjny = b.sjny
FROM A LEFT JOIN B ON A.sfzno = B.sfzno
from a left join b
on a.sfzno = b.sfzno and a.yjny = b.sjny
insert into a values('XXXX' , '200801')
insert into a values('XXXX' , '200802')
insert into a values('XXXX' , '200803')
insert into a values('DDDD' , '200801')
create table b(sfzno varchar(18), sjny varchar(6),je int)
insert into b values('XXXX', '200801' , 100 )
insert into b values('XXXX', '200803' , 50)
insert into b values('DDDD', '200801' , 120)
insert into b values('DDDD', '200802' , 70 )
goselect a.sfzno,a.yjny,b.sjny,b.je
from a left join b
on a.sfzno = b.sfzno and a.yjny = b.sjny
order by a.sfzno,a.yjnydrop table a , b
/*
sfzno yjny sjny je
------------------ ------ ------ -----------
DDDD 200801 200801 120
XXXX 200801 200801 100
XXXX 200802 NULL NULL
XXXX 200803 200803 50(所影响的行数为 4 行)
*/