Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
Help!!!
Collapse
X
-
Tags: None
-
Can you give us any more specifics?Originally posted by ghostriderOkay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
What kind of program are you writing, what are the specs? What platform/programming language are you using? -
I'm using MS SQL 2005 Express. I'm trying to write a INSERT statement pulling data from my online school database and I'm not sure how to do it.Comment
-
If I understand correctly, you are trying to insert data from one table into another.Originally posted by ghostriderI'm using MS SQL 2005 Express. I'm trying to write a INSERT statement pulling data from my online school database and I'm not sure how to do it.
If these tables exist on different platforms you will need to write an application that does this.
I will assume both tables are in the same database.
INSERT INTO Table1(Column1, Column2)
SELECT Column1,Column2
FROM Table2Comment
-
Comment