i want to insert multiple rows in multiple columns in single query using two different temp tables named `#temp1` having col QID and `#temp2` having col RID and i tried like this

```
insert into table1(ID,quetion,rating) select @ID,QID,RID from #Temp1,#temp2

```

when i am inserting the data it looking like this

```
 ID  Quest   Rate
    2   1   5
    2   2   5
    2   3   5
    2   1   4
    2   2   4
    2   3   4
    2   1   3
    2   2   3
    2   3   3

```

but i want to insert like this

```
ID  Quest Rate
2   1   5
2   2   4
2   3   3

```

Thank in Advance: