liuyunxt
liuyunxt
关注数: 30
粉丝数: 1
发帖数: 129
关注贴吧数: 3
SQL用什么语句可以把下面的两个表的内容连接起来? 表一sDeptNO thQty thAmount22413.0006204.82000002380.000186.90000003228.000668.420000033105.0005013.27000003592.0001886.750000036186.0001991.630000037217.0003195.51000003856.0002520.0000000表二sDeptNO jhQty jhAmount207187.000 76261.56000002217753.000 61995.8432000232532.000 12103.5000000319967.000 75121.7800000329075.000 28011.190000033701.000 36084.430000034141.000 54005.00000003521440.000 303784.4809000363410.000 35223.150000037105.000 1279.000000038228.000 6128.6000000现在要将表一和表二的数据连接起来结构如下sDeptNO thQty thAmount jhQty jhAmount需要保留有表二中的记录数(即11条记录)谢谢
急求繁体Win2000个人版或98版 各位大虾: 不知哪位有繁体Win2000个人版或98版呀,能否搞个链接??谢了先,急~~~!!!
1
下一页