多表SQL例子

SELECT orders.*,items.* FROM orders,orders_items_relation,items WHERE orders.orders_id=orders_items_relation.orders_id AND orders_items_relation.items_id=items.items_id;

SELECT items.* FROM USER,orders,orders_items_relation,items WHERE user.username='张三丰' AND user.user_id=orders.user_id AND orders.orders_id=orders_items_relation.orders_id AND orders_items_relation.items_id=items.items_id;

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/yuyu666/p/12423302.html