SQL insert to fill an associative table with conditions

Question

I have two tables and an associative table between them (let's call them Tab1, Tab2 and ATab).

Tab1 and Tab2 have those very same fields (for example purpose) :

In my ATab, I want to insert record to associates Tab1 and Tab2 with their Ids.

In order to do so, I would like to write my query in a sql script that say something like :

I can manage to do something like :

INSERT INTO ATab(Tab1Id, Tab2Id) 
SELECT Tab1.Id, ????? 
FROM Tab1 WHERE Tab1.Name='Foo';

But I'm selecting only the Foo record of my first table...

How would I manage to perform a "double" where clause ? Is it possible ?

Oh dear... :) Seems that I was looking way to far >. – Andy M Sep 17 '12 at 07:56 — Andy M, Sep 17 '12 at 07:56

score 6 · Accepted Answer · answered Sep 17 '12 at 07:59

6

by using AND

INSERT INTO ATab(Tab1Id, Tab2Id) 
(SELECT Tab1.Id, Tab2.Id
FROM Tab1, Tab2 WHERE Tab1.Name = 'Foo' AND Tab2.Name = 'Bar')

answered Sep 17 '12 at 07:59

epoch

no problem :), just added `, Tab2` before the where clause as well – epoch Sep 17 '12 at 08:14

1 Answers1