Anonymous

UPDATE opportunitiesCASE opportunities.datum_productWHEN 'SWS' THEN opportunities.product_id = 1;WHEN 'WSF' THEN opportunities.product_id = 2;WHEN 'WSF (adjustable)' THEN opportunities.product_id = 3;WHEN 'SMT' THEN opportunities.product_id = 4;WHEN 'PFJ' THEN opportunities.product_id = 5;WHEN '5DX' THEN opportunities.product_id = 6;WHEN 'Assembly Tooling' THEN opportunities.product_id = 7;WHEN 'Tooling' THEN opportunities.product_id = 8;WHEN 'Print Support Tooling' THEN opportunities.product_id = 9;WHEN 'Conformal Coat Fixture' THEN opportunities.product_id = 10;WHEN 'Flying Probe Fixture' THEN opportunities.product_id = 11;WHEN 'Inspection Template' THEN opportunities.product_id = 12;WHEN 'Pneumatic Press Tooling' THEN opportunities.product_id = 13;WHEN 'Pneumatic Press Small' THEN opportunities.product_id = 14;WHEN 'Pneumatic Press Large' THEN opportunities.product_id = 15;WHEN 'Mods' THEN opportunities.product_id = 16;WHEN 'Other' THEN opportunities.product_id = 17;ELSE SELECT * FROM product_types;END CASE;