-- RIGHT JOIN: 查询所有订单及其用户信息 SELECT o.order_id, o.amount, u.name, u.email FROM users u RIGHT JOIN orders o ON u.id = o.user_id WHERE o.status = 'pending'; -- 查询订单和支付记录 SELECT o.order_id, o.amo
-- RIGHT JOIN: 查询所有订单及其用户信息 SELECT o.order_id, o.amount, u.name, u.email FROM users u RIGHT JOIN orders o ON u.id = o.user_id WHERE o.status = 'pending'; -- 查询订单和支付记录 SELECT o.order_id, o.amo