请尝试使用此

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