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

2018年5月26日 0条评论 1点热度 阅读全文