使用联接插入查询 [英] Insert query using joins

问题描述

你好，
我有一个约有30列的表格.
我编写了一个存储过程，以使用来自各种表的联接将数据插入表中.
加入时我有条件，即

Hello,
I have a table with some 30 columns.
I have written a storeprocedure to insert data into Table using joins from various table.
in join i have where condition i.e

insert into Test([col1],[col2])
select a.Name,b.sub
from IdTable b
join  Nametable a ON b.no = a.no

IdTable中没有PK.
查询正在执行，但(影响0行)
请帮助

no is PK in IdTable.
query is executing but (0 row(s) affected)
Please help

推荐答案

请尝试使用此

Please try this one

INSERT INTO Test([col1],[col2])
(SELECT a.Name AS [col1],b.sub AS [col2] 
 FROM IdTable b INNER JOIN Nametable a ON b.no = a.no)

如果有任何问题然后对问题进行答复并解决，则必须进行答复

IF ANY PROBLEM THEN REPLY WITH PROBLEM AND SOLVED THEN REPLY MUST

这篇关于使用联接插入查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！