SQL:INSERT INTO ... VALUES..SELECT [英] SQL: INSERT INTO...VALUES..SELECT

问题描述

如果我从TableX获得colA，从TableY获得colB和从TableZ获得colC的值，该如何写INSERT语句?

How do i write INSERT statement if i get the values of colA from TableX, colB from TableY and colC from TableZ?

例如:插入到TableA(colA，colB，colC)值(?，?，?)

eg: INSERT INTO TableA (colA, colB, colC) VALUES (?,?,?)

有什么可能的想法吗?

推荐答案

INSERT INTO TableA(colA, colB, colC)
  SELECT TableX.valA, TableY.valB, TableZ.valC
    FROM TableX
   INNER JOIN TableY ON :......
   INNER JOIN TableZ ON ........

当然，TableX，TableY和TAbleZ也可能以其他方式关联(而不是INNER JOIN).

Of course, TableX, TableY and TAbleZ might also be related in some other way (not INNER JOIN).

如果根本找不到表之间的任何关系，也可以做三个单独的

If you cannot find any relation between the tables AT ALL, you could also do three separate

SELECT @value1 = valA FROM TableX WHERE ......
SELECT @value2 = valB FROM TableY WHERE ......
SELECT @value3 = valC FROM TableZ WHERE ......

，然后插入类似这样的内容:

and then an insert like this:

INSERT INTO TableA(colA, colB, colC)
             VALUES(@value1, @value2, @value3)

这是最终的万不得已的方法，您无法在单个SELECT语句中表达所有内容.

That's the ultimate last resort, you can can't express everything in a single SELECT statement.

马克

这篇关于SQL:INSERT INTO ... VALUES..SELECT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！