查询客户姓名为"孙丽娜"的订单信息，包括name、order_id、order_date、item_name、quantity、address、city。

Question

查询客户姓名为"孙丽娜"的订单信息，包括name、order_id、order_date、item_name、quantity、address、city。

是要把这几个表连接起来再查么？

Answer 1

内连接即可，注意连接条件。

select c.name, o.order_id, o.order_date, i.item_name, d.quantity, o.address, o.city
from customers c join orders o on c.customer_id=o.customer_id
   join order_details d on o.order_id=d.order_id
   join tiems i on d.item_id=i.item_id
where c.name='孙丽娜'

或者这样

select c.name, o.order_id, o.order_date, i.item_name, d.quantity, o.address, o.city
from customers c, orders o, order_details d, tiems i
where c.name='孙丽娜' and c.customer_id=o.customer_id
    and o.order_id=d.order_id
    and d.item_id=i.item_id