sql语句问题。help sos

Question

有A B两张表里面的字段列名完全一致只有数据不一致。。现在要把A B两张中不同数据插入到A表中。数据不只一条。一条insert语句够吗？怎么做？希望大神能给条实例代码谢谢 字段写两个就够了

Answer 1

    CREATE TABLE #a(col1 VARCHAR(20),col2 VARCHAR(20))

CREATE TABLE #b(col1 VARCHAR(20),col2 VARCHAR(20))

INSERT INTO #a( col1, col2 )
SELECT 'text1','text2'
UNION SELECT 'text1','text3'
UNION SELECT 'text1','text4'

INSERT INTO #b( col1, col2 )
SELECT 'text1','text2'
UNION SELECT 'text2','text3'
UNION SELECT 'text2','text4'

SELECT * FROM #a

SELECT * FROM #b

INSERT INTO #a
        ( col1, col2 )
SELECT col1, col2
FROM #b b WHERE NOT EXISTS(SELECT 1 FROM #a a WHERE a.col1=b.col1 AND a.col2=b.col2)

SELECT * FROM #a

DROP TABLE #a

DROP TABLE #b 

---

col1 col2

---

text1 text2
text1 text3
text1 text4

col1 col2

---

text1 text2
text2 text3
text2 text4

col1 col2

---

text1 text2
text1 text3
text1 text4
text2 text3
text2 text4