题解 | #返回顾客名称和相关订单号#
返回顾客名称和相关订单号
https://www.nowcoder.com/practice/7e7bc361db6a4cb6aa35eefccfe75364?tpId=298&tqId=2374696&ru=/exam/oj&qru=/ta/sql-teach-yourself/question-ranking&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D298
select cust_name,order_num from Customers,Orders where Customers.cust_id=Orders.cust_id order by cust_name,order_num #简单的等联结语法 #方法二：内连接 select cust_name,order_num from Customers inner join Orders on Customers.cust_id=Orders.cust_id order by cust_name,order_num
查看13道真题和解析
