title: How to SQL INSERT CROSS JOIN with other parameters
body: <p>I am writing a query to insert data into a table.  This query must select certain id's from two separate tables as well as a passed in parameter.  I was able to get the data from the two separate tables by using CROSS JOIN.  However, I'm not sure how to pass in a string as my third parameter.  Here is my statement:</p>
  
  <pre><code>INSERT INTO TABLE1 (T2_ID, T3_ID)
  SELECT T2_ID, T3_ID
  FROM (SELECT T2_ID FROM TABLE2 WHERE TABLE2.NAME = 'BOB') AS T1
  CROSS JOIN(SELECT T3_ID FROM TABLE3 WHERE TABLE3.DATA = 'BLARGH') AS T2;
  </code></pre>
  
  <p>I get the ID's I need back from the cross join but I also need to pass in one more parameter that is a string value.  How do I pass this in as well?  Thank you in advance.</p>