MySql中USING用法
using等价于join操作中的on
‘ U S I N G ‘ 代 码 实 例 \color{#FF0000}{`USING`代码实例} ‘USING‘代码实例
SELECT cust_name, order_num
FROM Orders INNER JOIN Customers USING(cust_id)
ORDER BY cust_name;
‘ J O I N O N ‘ 代 码 实 例 \color{#FF0000}{`JOIN ON`代码实例} ‘JOINON‘代码实例
select
Customers.cust_name,
Orders.order_num
from
Customers
inner join Orders on Orders.cust_id = Customers.cust_id
order by Customers.cust_name