469,315 Members | 1,609 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,315 developers. It's quick & easy.

Help!!!

Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
Jul 11 '07 #1
5 887
Infide
28
Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
Can you give us any more specifics?

What kind of program are you writing, what are the specs? What platform/programming language are you using?
Jul 11 '07 #2
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.
Jul 11 '07 #3
srinit
43
Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
Hi,
can you tell me clearly your requirements.really you want help for creating tables
Jul 11 '07 #4
Infide
28
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.
If I understand correctly, you are trying to insert data from one table into another.

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 Table2
Jul 11 '07 #5
Thanks this is what I was looking for. Thanks again!!!!
Jul 11 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Tom | last post: by
6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by
8 posts views Thread by Mark | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.