title: Create a view from Select statement with multiple subqueries / joins
body: <p>So I have multiple tables and I'm trying to create a view to show everything as returned in my select statement. However it seems that mysql does not allow to create Views which have subqueries in from.</p>
  
  <p>So not really sure how to convert this to a view.</p>
  
  <pre><code>Select  Title as "AlbumName" , 
          Sum(trk1.Price * trk1.Quant) as "TotalSales"
  From    Album alb
          INNER JOIN
          (
              SELECT  AlbumId, 
                      t1.UnitPrice as "Price" , 
                      t1.Quantity as "Quant"
              FROM    Track trk
                      INNER JOIN
                      (
                          SELECT  TrackId, UnitPrice, Quantity
                          FROM    InvoiceLine
                          WHERE   InvoiceId IN ( SELECT InvoiceId FROM Invoice )
                      ) AS t1 ON (trk.TrackId = t1.TrackId)
          ) as trk1 ON (alb.AlbumId = trk1.AlbumId)
  Group By alb.AlbumId
  </code></pre>