两个无关联性的表组合问题

[xiaopingatrry]

如：
表1
name
iPhone6
iPhone6S
iPhone7

表2
model
红色
银色
玫瑰金

想要的效果表结构为
name model
iPhone6 红色
iPhone6 银色
iPhone6 玫瑰金
iPhone6s 红色
iPhone6s 银色
iPhone6s 玫瑰金
iPhone7 红色
iPhone7 银色
iPhone7 玫瑰金

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('t1') IS NOT NULL DROP TABLE t1
IF OBJECT_ID('t2') IS NOT NULL DROP TABLE t2
CREATE TABLE t1([name] VARCHAR(20))
CREATE TABLE t2([model] NVARCHAR(20))
INSERT INTO t1 VALUES ('iPhone6')
INSERT INTO t1 VALUES ('iPhone6S')
INSERT INTO t1 VALUES ('iPhone7')
INSERT INTO t2 VALUES ('红色')
INSERT INTO t2 VALUES ('银色')
INSERT INTO t2 VALUES ('玫瑰金')
SELECT t1.name,t2.model FROM t1 CROSS APPLY t2
/*
name	model
iPhone6	红色
iPhone6S	红色
iPhone7	红色
iPhone6	银色
iPhone6S	银色
iPhone7	银色
iPhone6	玫瑰金
iPhone6S	玫瑰金
iPhone7	玫瑰金
*/

[顺势而为1]

if not object_id(N'Tempdb..#Tmp_Data1') is null
    drop table #Tmp_Tmp_Data1
Go

CREATE TABLE #Tmp_Tmp_Data1([name] VARCHAR(20))

if not object_id(N'Tempdb..#Tmp_Data2') is null
    drop table #Tmp_Tmp_Data2
Go

CREATE TABLE #Tmp_Tmp_Data2([model] NVARCHAR(20))

INSERT INTO #Tmp_Tmp_Data1 VALUES ('iPhone6')
INSERT INTO #Tmp_Tmp_Data1 VALUES ('iPhone6S')
INSERT INTO #Tmp_Tmp_Data1 VALUES ('iPhone7')
INSERT INTO #Tmp_Tmp_Data2 VALUES (N'红色')
INSERT INTO #Tmp_Tmp_Data2 VALUES (N'银色')
INSERT INTO #Tmp_Tmp_Data2 VALUES (N'玫瑰金')

Select *
From #Tmp_Tmp_Data1 a Join #Tmp_Tmp_Data2 b on 1=1

[0与1之间]

with T1(name) as 
(
	select 'iPhone6' Union All
	select 'iPhone6S' Union All
	select 'iPhone7'
), T2(model) as 
(
	select '红色'  Union All
	select '银色'  Union All
	select '玫瑰金'
)
select * from T1,T2

[zhouyuehai1978]

直接join就可以了呀

[二月十六]

SELECT  *
FROM    T1 ,
        T2
ORDER BY name