带一组常量的insert into的SQL查询

我有一张有两个主键的桌子

我相信你想要这个:

INSERT
INTO    awesometable (id1, id2)
SELECT  t1.id1, q.id2
FROM    table1 t1
CROSS JOIN
        (
        SELECT  0 AS id2
        UNION ALL
        SELECT  3
        UNION ALL
        SELECT  5
        UNION ALL
        SELECT  6
        UNION ALL
        SELECT  9
        ) q

Oracle

INSERT
INTO    awesometable (id1, id2)
SELECT  t1.id1, q.id2
FROM    table1 t1
CROSS JOIN
        (
        SELECT  0 AS id2
        FROM    dual
        UNION ALL
        SELECT  3
        FROM    dual
        UNION ALL
        SELECT  5
        FROM    dual
        UNION ALL
        SELECT  6
        FROM    dual
        UNION ALL
        SELECT  9
        FROM    dual
        ) q

如果我理解正确,也许你可以用这样的方法:

insert into awesometable (id1, id2) 
select id1, (select top 1 id2 from table2 where /*a condition here to retreive only one result*/) 
from table1