表一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.
15000003710
5.000 1279.000000038228.000 6128.6000000现在要将表一和表二的数据连接起来结构如下sDeptNO thQty thAmount jhQty jhAmount需要保留有表二中的记录数（即11条记录）谢谢