我想合并两个表,并从内部联接的结果表中减go 左联接结果表中的订单数.
WITH t1 AS (
SELECT *
FROM orders
LEFT JOIN food ON orders.id = food.id
),
t2 AS (
SELECT *
FROM orders
INNER JOIN food ON orders.id = food.id
)
SELECT
/* now what? */
现在我想减go 两个表中的行数.
我不知道该怎么做,我是否应该再次加入表格并做减法,有没有更简单的方法?