WITH 自定义表名称 AS

一个SQL小技巧，用SELECT查询数据并赋给一个临时表，并使用该临时表关联其他表再次查询数据。

WITH CartPOClo AS
(
    SELECT CartonCode,PONum
    FROM Bn_CartClothing 
)
SELECT C.CartonCode,D.CartonNum,D.CartStoreNum
FROM CartPOClo C 
LEFT JOIN    Bn_CartonInfo D ON C.CartonCode=D.CartonCode 

 这里有个地方需要注意，如果你想连续多次：WITH CartPOClo AS

格式是这样的：

WITH  tb1 AS 
( SELECT   name,
    age
  FROM  table1
),

tb2 AS 
( SELECT   name,
    age
  FROM table2
),

tb3 AS 
( SELECT  name,
    age
  FROM table3
)