--??這個意思?
SELECT SUM(i.qty) AS qty , i.sku_name AS sku_name,
color.code AS color , b.name AS branch_name , sku.code AS code
FROM cue_order_item i
JOIN cue_order o ON o.id = i.order_id
LEFT OUTER JOIN branch b ON b.id = o.branch_id
LEFT OUTER JOIN sku_item si ON si.barcode = i.barcode
LEFT OUTER JOIN sku ON sku.id = si.sku_id
LEFT OUTER JOIN sku_option_color color ON color.code = si.sku_color_code WHERE i.barcode LIKE 'C016%' AND o.date_created >= '2008-05-01' AND o.date_created < '2008-05-04'
GROUP BY i.sku_name, color.code , b.name, sku.code
SELECT SUM(i.qty) AS qty , i.sku_name AS sku_name,
color.code AS color , b.name AS branch_name , sku.code AS code
FROM cue_order_item i
JOIN cue_order o ON o.id = i.order_id
LEFT OUTER JOIN branch b ON b.id = o.branch_id
LEFT OUTER JOIN sku_item si ON si.barcode = i.barcode
LEFT OUTER JOIN sku ON sku.id = si.sku_id
LEFT OUTER JOIN sku_option_color color ON color.code = si.sku_color_code WHERE i.barcode LIKE 'C016%' AND o.date_created >= '2008-05-01' AND o.date_created < '2008-05-04'
GROUP BY i.sku_name, color.code , b.name, sku.code
color.code AS color , b.name AS branch_name , sku.code AS code
FROM cue_order_item i
JOIN cue_order o ON o.id = i.order_id
LEFT OUTER JOIN branch b ON b.id = o.branch_id
LEFT OUTER JOIN sku_item si ON si.barcode = i.barcode
LEFT OUTER JOIN sku ON sku.id = si.sku_id
LEFT OUTER JOIN sku_option_color color ON color.code = si.sku_color_code WHERE i.barcode LIKE 'C016%' AND convert(varchar(10),o.date_created,120) >= '2008-05-01' AND convert(varchar(10),o.date_created,120) < '2008-05-04'
GROUP BY b.name --把时间格式转换一下试下.select convert(varchar(10),getdate(),120) result/*
result
-----------
2008-06-14
*/