RIGHT JOIN和FULL JOIN

课程:SQL · 编程练习

SQL编程练习 - RIGHT JOIN和FULL JOIN

练习内容

-- RIGHT JOIN: 查询所有订单及其用户信息\nSELECT o.order_id, o.amount, u.name, u.email\nFROM users u\nRIGHT JOIN orders o ON u.id = o.user_id\nWHERE o.status = 'pending';\n\n-- 查询订单和支付记录\nSELECT\n o.order_id,\n