首页
Python
Java
前端
数据库
Linux
Chatgpt专题
开发者工具箱
sql96专题
SQL96 返回顾客名称和相关订单号(表的普通联结、内联结inner join..on..)
方法一:普通联结 select cust_name, order_num from Customers C,Orders O where C.cust_id = O.cust_id order by cust_name,order_num; 方法二:使用内连接 select cust_name,order_num from Customers C inner join Orders O
阅读更多...