插入多个子查询作为值

本文介绍了插入多个子查询作为值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

假设我必须插入一个有很多 fk 的表，只是为了在下面解释错误的陈述:

Lets suppose I've to insert into a table with many fk, just to explain here below the wrong statement:

insert into mytable values ( somevalue ,somevalue ,select id from othertable1 where ...condition ,select id from othertable2 where ...condition ,select id from othertable3 where ...condition )

所以基本上要插入的值来自不同的子查询，是否有可能实现这样的行为?

so basically values to insert comes from different subqueries, is it possible to achieve such a behavior ?

推荐答案

insert into mytable (columns) select somevalue, somevalue, a.id, b.id, c.id from othertable1 a cross join othertable2 b cross join othertable3 c where a ... condition b ... condition c ... condition