INSERT INTO and Select statement

[montejr]

Gang,
I am trying to populate the records of one field based on the value of another field. So if I have a value of 1 as my plan_id, I want the value of my Plan_Name to be plan1.

Essentially, I need to write a query to select a bunch of records and populate another field with new values based on the selected records. Here is my syntax so far:

INSERT INTO PascoCounty_Parcels (Plan_Name) VALUES (Plan1) SELECT * from PascoCounty_Parcels where PlanID = 1;

I get a "missing semicolon at end of SQL Statement" message. I think my syntax is wrong - it's been a while since I have done this.

Thanks,
Monte

 

[gol4]

since it appears you are working on the same table I think what you are really looking for is an update query

UPDATE PascoCounty_Parcels SET Plan_Name = "plan1"
WHERE PlanID = 1;

 

[montejr]

Gol4,
Thanks so much for the help. You are a life saver. Big demo coming up and this solved my problem. I cannot thank you enough.

Cheers,
Monte

 

[PHV]

Anyway, have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886