SQL INSERT INTO from multiple tables

by

You only need one INSERT:

INSERT INTO destinationTable( name, age, sex, city, id, number, nationality)
SELECT name, age, sex, city, s1.id, number, s3.nationality
FROM sourceTable1 s1
INNER JOIN sourceTable2 s2 ON s2.Id = s1.Id
INNER JOIN sourceTable3 s3 ON s3.Id = s1.Id

More Related Contents:

  1. How to calculate age (in years) based on Date of Birth and getDate()
  2. CROSS JOIN vs INNER JOIN in SQL
  3. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  4. INNER JOIN vs LEFT JOIN performance in SQL Server
  5. Limit on the WHERE col IN (…) condition
  6. Get day of week in SQL Server 2005/2008
  7. Getting result of dynamic SQL into a variable for sql-server
  8. How to get difference between two rows for a column field?
  9. Simple Query to Grab Max Value for each ID
  10. SQL Server: Extract Table Meta-Data (description, fields and their data types)
  11. SQL Server 2008: how do I grant privileges to a username?
  12. SQL Server SELECT into existing table
  13. Insert Into… Merge… Select (SQL Server)
  14. The parameterized query expects the parameter which was not supplied
  15. SQL Server: drop table cascade equivalent?
  16. How to insert a blob into a database using sql server management studio
  17. SQL Server converting varbinary to string
  18. Incorrect syntax near ”
  19. How do I prevent a database trigger from recursing?
  20. Execution sequence of Group By, Having and Where clause in SQL Server?
  21. SQL Server Operating system error 5: “5(Access is denied.)”
  22. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  23. Aggregate function in an SQL update query?
  24. UNION the results of multiple stored procedures
  25. How to pass a temp table as a parameter into a separate stored procedure
  26. Executing SQL Server Agent Job from a stored procedure and returning job result
  27. Select statement to return parent and infinite children
  28. SQL Server Query time out depending on Where Clause
  29. Compare dates in T-SQL, ignoring the time part
  30. Should I use the CASCADE DELETE rule? [duplicate]

Leave a Comment