sql - 加入四张表结果正确加入第五张表后出现重复和错误结果

Question

我要加入五张桌子：

1. Deliveries_shipped
2. 送货
3. 纸盒
4. 顾客
5. 要求

加入最后一个表以获取数量列后，给出重复的行？我执行了这个查询

SELECT c.carton_id, 
       c.delivery_id, 
       weight, 
       c.datetime_stamp, 
       carton_dim, 
       tracking_number, 
       ship_date, 
       d.customer_id, 
       status, 
       packer, 
       purchase_order_number, 
       customer_name1, 
       street_address, 
       cus.city, 
       city2, 
       country_code 
FROM   carton AS c 
       INNER JOIN deliveries_shipped AS ds 
               ON c.carton_id = ds.carton_id 
                  AND c.delivery_id = ds.delivery_id 
       INNER JOIN delivery AS d 
               ON d.delivery_id = c.delivery_id 
       INNER JOIN customer AS cus 
               ON cus.delivery_id = c.delivery_id 
WHERE  c.delivery_id = '0097301587'; 

这里有三行 carton_id 即将到来，而这三个纸箱 ID 的数量5000,1000,1000如何获得？

标签： sqlsql-server