INSERT INTO double select - how?
<p>I'm trying to insert two values from two select statements, something like:</p>

<pre><code>INSERT INTO manytomany_relation_a_and_b_tables (a_id, b_id) VALUES 
(SELECT id FROM a_table WHERE someColumnFromA="SOMETHING"), 
(SELECT id FROM b_table WHERE someColumnFromB="SOMETHING");
</code></pre>

<p>Obviously it doesn't work, but how can I achieve effect which I want?</p>