13.5.5 使用复合连接条件查询数据
MySQL中的JOIN语句支持使用多个连接条件查询数据,语句格式如下:
SELECT table1.column, table2.column
FROM table1 INNER | LEFT | RIGHT | CROSS JOIN table2
ON table1.col = table2.col
AND table1.col = value1
[AND table2.col = value2 ….]
例如,使用LEFT JOIN语句查询t_goods和t_goods_category表中商品类别id为1的数据:
mysql> SELECT category.t_category, goods.t_name
-> FROM t_goods_category category
-> LEFT JOIN t_goods goods
-> ON category.id = goods.t_category_id
-> AND category.id = 1;
+----------------+-------------+
| t_category | t_name |
+-------------