title: SELECT CASE WHEN THEN (SELECT)
body: <p>I am trying to select a different set of results for a product depending on a product type.
  So if my product should be a book I want it to look up the UPC and Artist for a normal product these details are however irrelevant and for another product I would want a completely different set of results.</p>
  
  <pre><code>SELECT CASE Product.type_id
      WHEN 10 THEN (
          SELECT 
          Product.product_id, 
          Product.type_id, 
          Product.product_name, 
          Product.UPC,
          Product_Type.type,
          CONCAT_WS(' ' , first_name, middle_name, last_name ) AS artistC 
          FROM Product, Product_Type, Product_ArtistAuthor 
          WHERE Product.type_id = Product_Type.type_id 
          AND Product.product_id = $pid
          AND Product.artist_id = Product_ArtistAuthor.artist_id
      )
      ELSE (
          SELECT 
          Product.product_id, 
          Product.type_id, 
          Product.product_name,
          Product_Type.type 
          FROM Product, Product_Type 
          WHERE Product.type_id = Product_Type.type_id 
          AND Product.product_id = $pid
      )
  END
  FROM Product 
  WHERE Product.product_id = $pid
  </code></pre>
  
  <p>I am not sure where I am going wrong</p>