Category =
CASE ProductLine
WHEN 'R' THEN 'Road'
WHEN 'M' THEN 'Mountain'
WHEN 'T' THEN 'Touring'
WHEN 'S' THEN 'Other sale items'
ELSE 'Not f……
[/Quote]
Category =
CASE ProductLine
WHEN 'R' THEN 'Road'
WHEN 'M' THEN 'Mountain'
WHEN 'T' THEN 'Touring'
WHEN 'S' THEN 'Other sale items'
ELSE 'Not for sale'
END,
好比:
if(ProductLine='R')
Category = 'Road';
else if(ProductLine='M')
Category = 'Mountain';
else if(ProductLine='T')
Category = 'Touring';
....
else
Category = 'Not for sale';
SELECT 垛号
max(CASE WHEN 序号=1 THEN 数量 ELSE 0 END) AS dy,
max(CASE WHEN 序号=2 THEN 数量 ELSE 0 END) AS de,
max(CASE WHEN 序号=3 THEN 数量 ELSE 0 END) AS dsa,
SUM(数量) AS 'sweight'
FROM wl_packinglist_d