hi, I have gthe following query:
select proj_id
from msp_text_fields
group by proj_id;
this gives me a list of all of the proj_ids in the table.
I want to update a second table with all of these values.
The second table has the same column (proj_id) but has other columns aswell.
I have tried:
insert into msp_synchtable (proj_id) VALUES
(select proj_id
from msp_text_fields
group by proj_id)
but this doesn't work.
can anyone tell me where I am going wrong?
I get an error in line two saying missing expression.
select proj_id
from msp_text_fields
group by proj_id;
this gives me a list of all of the proj_ids in the table.
I want to update a second table with all of these values.
The second table has the same column (proj_id) but has other columns aswell.
I have tried:
insert into msp_synchtable (proj_id) VALUES
(select proj_id
from msp_text_fields
group by proj_id)
but this doesn't work.
can anyone tell me where I am going wrong?
I get an error in line two saying missing expression.