×îºó25·Ö,Çó±ä̬SQL - MS-SQL Server / »ù´¡Àà

c1 c2
1 x
2 x
3 x
4 x
5 x
6 x
7 x


x1 x2
a x
b x
c x
---½á¹û
c1 c2 x1 x2
1 x a x
2 x b x
3 x c x


±í2¹²n(3)ÐÐ,±í1Ò²Ö»ÏÔʾn(3)ÐÐ.

±í1,±í2,ÎÞÈκιØÁª. °´Ë³ÐòºÅ¹ØÁª¼´¿É.

°¦,רÃÅÎʱä̬SQL ²»ºÃÒâ˼.

---

SQL code:
----------------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-05-13 10:57:44
-- 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)
-- Blog : http://blog.csdn.net/htl258
----------------------------------------------------------------------------------

--> Éú³É²âÊÔÊý¾Ý±í: [ta]
IF OBJECT_ID('[ta]') IS NOT NULL
DROP TABLE [ta]
GO
CREATE TABLE [ta] ([c1] [int],[c2] [nvarchar](10))
INSERT INTO [ta]
SELECT '1','x' UNION ALL
SELECT '2','x' UNION ALL
SELECT '3','x' UNION ALL
SELECT '4','x' UNION ALL
SELECT '5','x' UNION ALL
SELECT '6','x' UNION ALL
SELECT '7','x'

--> Éú³É²âÊÔÊý¾Ý±í: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb] ([x1] [nvarchar](10),[x2] [nvarchar](10))
INSERT INTO [tb