title: How do I insert the results of a cross join into another table?
body: <p>I'm using this SQL to create a cross join and insert the results into a third  table. Any ideas why this doesn't work? The cross join works when run by itself. The insert also runs standalone but not when thet wo statements are merged.</p>
  
  <pre><code>INSERT INTO Person (FirstName, LastName) 
  VALUES (Select fn.Name, ln.Name from FirstName as fn cross join LastName as ln);
  </code></pre>