How to insert a range of keys in another column

Question

I've just gone blank. I have a many to many relationship with three tables. Lets call them A, B and C. C stores the primary keys of the other two tables.

Now, I would like to insert all primary keys from table A, and lets say primary key 1 from B into table C. I just don't get it. All I came up with was some stored procedure that runs with a cursor through all primary keys of A and insert them with 1 into C. Guess, there is a much easier way to do this.

Any help appreciated!

Answer 1

I would say:

INSERT INTO C
SELECT A_Id, 1
FROM A

where 1 is the single primary key from B.

Check here for more info on the INSERT statement.