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?

Quote:

Originally Posted by ghostrider

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?|||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.|||

Quote:

Originally Posted by ghostrider

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|||

Quote:

Originally Posted by ghostrider

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|||Thanks this is what I was looking for. Thanks again!!!!