求一SQL - MS-SQL Server / 基础类

表A

F_BM F_Name
001  
001001
001002
001003 

表B
F_BM F_SL
001001 100
001002 50
001003 20


怎么整出
A.F_BM B.F_SL
001 170
001001 100
001002 50
001003 20
求一SQL

---

SQL code:
select a.F_BM,b. B.F_SL from ta a, tb b where a.F_BM=b.F_BM

---

引用

SQL code
select a.F_BM,b. B.F_SL from ta a, tb b where a.F_BM=b.F_BM

不好意思看错了

---

SQL code:
--------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-22 14:33:40
-- Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
-- Jul 9 2008 14:43:34
-- Copyright (c) 1988-2008 Microsoft Corporation
-- Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
--------------------------------------------------------------------------
--> 生成测试数据表:a

IF NOT OBJECT_ID('[a]') IS NULL
DROP TABLE [a]
GO
CREATE TABLE [a]([F_BM] NVARCHAR(10),[F_Name] NVARCHAR(10))
INSERT [a]
SELECT '001',NULL UNION ALL
SELECT '001001',NULL UNION ALL
SEL