insert into Test([col1],[col2]) select a.Name,b.sub from IdTable b join Nametable a ON b.no = a.no
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)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)