By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 182 Duplicates: 0 Warnings: 0
Records: 70 Duplicates: 0 Warnings: 0
| @sql |
|---|
| SELECT SUM( CASE WHEN product_code = "ALFA PLUS FSC" THEN available_quantity ELSE 0 END) AS `ALFA PLUS FSC`,SUM( CASE WHEN product_code = "ALFA PLUS" THEN available_quantity ELSE 0 END) AS `ALFA PLUS`,SUM( CASE WHEN product_code = "ANTI FUNGAL CYBERXL PAC - FSC 250 RL." THEN available_quantity ELSE 0 END) AS `ANTI FUNGAL CYBERXL PAC - FSC 250 RL.`,SUM( CASE WHEN product_code = "ANTI FUNGAL CYBERXL PAC - FSC 250 SH" THEN available_quantity ELSE 0 END) AS `ANTI FUNGAL CYBERXL PAC - FSC 250 SH`,SUM( CASE WHEN product_code = "ANTI FUNGAL CYBERXL PAC - FSC 285 RL" THEN available_quantity ELSE 0 END) AS `ANTI FUNGAL CYBERXL PAC - FSC 285 RL`,SUM( CASE WHEN product_code = "ART MAESTRO - P" THEN available_quantity ELSE 0 END) AS `ART MAESTRO - P`,SUM( CASE WHEN product_code = "BLUE CENTER ART CARD -FSC" THEN available_quantity ELSE 0 END) AS `BLUE CENTER ART CARD -FSC`,SUM( CASE WHEN product_code = "BRIGHT COAT SBS ART BOARD-FSC 300 RL" THEN available_quantity ELSE 0 END) AS `BRIGHT COAT SBS ART BOARD-FSC 300 RL`,SUM( CASE , SUM(available_quantity) as TOTAL FROM west_stock_details where consignee_name IN ("PARKSON PACKAGING LTD.", "PARKSONS PACKAGING LIMITED", "PARKSONS PACKAGING LIMITED.", "PARKSONS PACKAGING LTD.", "PARKSONS PACKAGING LTD.(PUNE)") and stor_loc_desc NOT IN ("BCM PG6 SL WH", "Quality HOLD Mat", "BCM PG5 MFS WH", "BCM PG4 MFS WH", "BCM PG7 MFS WH", "BCM PG4 SL WH", "BCM PG7 SL WH", "Damaged Stocks", "BCM PM1A MFS WH", "Bad Quality Matl", "MPBC-Bad quality", "BCM PG6 SL WH", "BCM PG7 SL WH") and storage_location NOT IN ("T400","BSL6","BC15","BC14","BC17","BSL4","BSL7","DS01","BC1A","BC04","BE06","BSL7","BSL","BCIC","MPSL","UVSL","T203","BSLA") and storage_location not like "%SL%" GROUP BY destination |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' SUM(available_quantity) as TOTAL FROM west_stock_details where consignee_name I' at line 1