//示例:
select a.*, b.* from a left join b using(colA);
//等同于:
select a.*, b.* from a left join b on a.colA = b.colA;
mysql中using的用法为:
using()用于两张表的join查询,要求using()指定的列在两个表中均存在,并使用之用于join的条件。
SELECT *
FROM order_items oi
JOIN order_item_notes oin
USING(order_id,product_id)
//等同于
SELECT *
FROM order_items oi
JOIN order_item_notes oin
ON oi.order_id = oin.order_id AND oi.product_id= oin.product_id