title: USE statement before CREATE VIEW
body: <p>The truth: I am not good at SQL, and after some research I am unable to figure this out. I am reading a chapter on utilizing views and am unable to get this query to work :</p>
  
  <pre><code>USE [jm0235242]
  CREATE VIEW InvoiceBasic 
  AS
  SELECT VendorName, InvoiceNumber, InvoiceTotal
  FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID
  </code></pre>
  
  <p>It has issues with my USE statement: </p>
  
  <blockquote>
    <p><em>'CREATE VIEW' must be the first statement in a query batch".</em></p>
  </blockquote>
  
  <p>My question is, how am I supposed to specify which database it is supposed to look at if I cannot use my USE statement. Thanks for any help, and happy thanksgiving!</p>