当表内有复合主键时进行表连接的方式SELECT *FROM order_items oiJOIN order_item_notes oinON oi.order_id = oin.order_idAND oi.product_id = oin.product_id