CODEWITHSUNDEEP
sqlsql-server-2008sql-insert
ChrisG
ChrisG

Reputation: 11

SQL pulling data from multiple tables to one table

I have a massive database (over 200 tables) and need to pull data from different ones to a new one. I am also hard coding some of the data using values as they are not stored within the database.

I understand pretty simple SQL however am struggling with the more advanced stuff. From researching I have found it is most likely going to work with the join command, however after a few tries I have been unsuccessful.

I was hoping if somebody could point me in the right direction to extend my research or to put me on the right tracks if the join isn't right. Not asking for this to be done for me just some pointers as I feel all I have tried have failed.

A brief example may also be helpful.

Upvotes: 1

Views: 1252

Answers (1)

RazorSky
RazorSky

Reputation: 360

You are going to need a JOIN if the data can join together, or a union if the data is in similar data in different tables. It will be very hard to help without at least some better ideas of what you're trying to do. Could you maybe provide some example data? Make sure to scrub the data before posting it online.

A great place to learn: http://www.w3schools.com/sql/sql_join.asp

Upvotes: 2

Related Questions