title: MySQL View with Union Error - "View's SELECT contains a subquery in the FROM clause"
body: <p>I'm getting this error and I don't know how to resolve.  It works fine as a normal query, but I'd like for it to be a view:</p>
  
  <pre><code>CREATE  OR REPLACE VIEW `myTable`.`vw_videos` AS
  
  SELECT DISTINCT theVideos.videoID FROM
      (SELECT video_youtube_id AS videoID FROM videos
      UNION
      SELECT entry_video AS videoID FROM vw_entry_info) AS theVideos
  WHERE videoID != "";
  </code></pre>
  
  <p>I keep getting "View's SELECT contains a subquery in the FROM clause".  Why is this?</p>