INSERT INTO table (column2) VALUES ('Blue') SELECT column1 FROM table WHERE column1 < 500 AND > 399;but this just gives errors in access. The other lady working on this project has had a SQL class but has had no luck remembering enough to do this.
Any help would be greatly appriciated, even links.
Note: I am not a SQL developer, nor do I use SQL much at all. This is for a project at my Internship.
This post has been edited by linuxunil: 16 June 2008 - 12:17 PM