ÇóÒ»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