原理不多少,直接上用法。
WITH
t1 as (SELECT * FROM Table1) ,
t2 as (SELECT * FROM Table2)
SELECT t1.*
FROM t1
LEFT JOIN t2 ON t1.id=t2.id
原理不多少,直接上用法。
WITH
t1 as (SELECT * FROM Table1) ,
t2 as (SELECT * FROM Table2)
SELECT t1.*
FROM t1
LEFT JOIN t2 ON t1.id=t2.id