Hello i have a matter with an insert query ill try to explain bellow :

Here is a simplify view of my tables 
[Tables](https://i.stack.imgur.com/NTjjj.png)

Table A         Table B   

ID / Number   ID  

1 / 0               1  

1 / 1               2  

1 / 2               3  

2 / 0               4  

2 / 1               5  

2 / 2               6  

3 / 0               7  

3 / 1               8  

3 / 2               9  

so i already have my query who select the id of table B not inside table A

I want to insert them in Table A but as you can see i need to insert them 3 time and after the first insert my query dont work anymore.

What is the best way to do this? Create a view? a tamporary table? or multiple query?

So thx to all who have answer here is the solution i used to achieve the matter:

```
//Here i get the Missing ID and put them inside temp Table
select ID into #temp_id from TableA rv left outer join TableB lrva on
rv.ID = lrva.ID where 'other Table B attribut'  is null

//Then i insert the values
insert into TableA select ID, 1 from #temp_id;
insert into TableA select ID, 2 from #temp_id;
insert into TableA select ID, 3 from #temp_id;

//Then destroy the temp table
Drop Table #temp_id

```

Keep in mind that i need specific treatment for the Number column as for other column i dont name on the exemple that s why i cant just do a +1 or things like this. The meaning of the question was just how to insert in the easyest way multiple id from other table, and not really how to achieve this in the exemple who as simple data.