title: SQL: How to join a view with a table?
body: <p>UPDATED:</p>
  
  <p>I am using MySQL statement to create a view:</p>
  
  <p>I need to show Editors First Name, Last Name and the City if they shipped more than 50 books. The three tables I have are:</p>
  
  <pre><code>create table editors (
   ed_id  char(11),
   ed_lname varchar(20),
    ed_fname varchar(20),
    ed_pos  varchar(12),
    phone  varchar(10),
    address  varchar(30),
    city  varchar(20),
    state  char(2),
    zip  char(5),
    ed_boss  char(11));
  
  create table titleditors (
   ed_id  char(11),
   title_id char(6),
   ed_ord  integer);
  
  create table salesdetails (
   sonum  integer,
   qty_ordered integer,
   qty_shipped integer,
   title_id char(6),
   date_shipped date);
  </code></pre>
  
  <p>Can anyone tell me what code would be to create this result?
  I didn't make the tables, I just have to work with what I was given.</p>