Computing.Net > Forums > Web Development > I need some SQL help

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

I need some SQL help

Reply to Message Icon

Name: eseloco
Date: October 29, 2004 at 11:44:34 Pacific
OS: windows
CPU/Ram: 256
Comment:

What SQL statement do I need to take all of the contents of several tables and make a new table.

For instance ... i have a database that has tables for different kinds of school classes... like a table for interent classes and a table for night classes.

how could i create a new table called allclasses that included both the internet and night classes.

i need it to be done in an sql statement

i am using microsoft access 2000.


thanks



Sponsored Link
Ads by Google

Response Number 1
Name: cannon19
Date: November 8, 2004 at 11:57:15 Pacific
Reply:

You can specify select * into allclasses from nighclasses

select * into allclasses internetclasses.

Not sure if Access lets you run sql statements but you can thru the GUI create new table allclasses and use import wizard to populate the data from two tables.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Web Development Forum Home


Sponsored links

Ads by Google


Results for: I need some SQL help

Guys I need some templates www.computing.net/answers/webdevel/guys-i-need-some-templates/625.html

I need some Web Dev help. www.computing.net/answers/webdevel/i-need-some-web-dev-help/3964.html

My site needs some color... www.computing.net/answers/webdevel/my-site-needs-some-color/2632.html