Wednesday, April 16, 2014

Use Multiple With Clause in one SQL Query

;With T (Name)
AS
(Select Top 1 Test1Name From Test), 
T2 (Name2) as
(
Select Top 1 Test2name From Test2
),
T3 (Name3) as
(
Select TOP 1 Test3Name From [Test3]
)
Select T.Name, T2.Name2, T3.Name3 From T, T2, T3

No comments:

Post a Comment