一個條件表(或暫存表)的資料，要拿去查詢多個資料表
範例1：用 WITH (CTE) 當單一來源查多個表
假設有一個清單：
SQL :
WITH UserList AS
(
SELECT 1 AS UserId
UNION ALL
SELECT 2
UNION ALL
SELECT 3
)
查詢 User 基本資料：
SQL :
WITH UserList AS
(
SELECT 1 AS UserId
UNION ALL
SELECT 2
UNION ALL
SELECT 3
)
SELECT * FROM Users U
INNER JOIN UserList UL ON U.UserId = UL.UserId;