copy records and create new record query

[dflow]

i have an old DB where i had a requests table

now in the new DB i can create several proposals per each request.

 

what im trying to do is create a proposal per each request with a specific statusID

in other words copy the request data with StatusID=4 into the proposals table as a new proposal

the tables have the schema besides primarykey RequestID in the Requests_tbl and ProposalsID in the Proposals_tbl

 

how should i approach this??

[Barand]

You could use an INSERT query

 

INSERT INTO propasal (a,b,c) SELECT (a,b,c) FROM request WHERE StatusID = 4

[dflow]

You could use an INSERT query

 

INSERT INTO propasal (a,b,c) SELECT (a,b,c) FROM request WHERE StatusID = 4

(a,b,c) are the fields?

if so what's the insert all syntax?

[dflow]

You could use an INSERT query

 

INSERT INTO propasal (a,b,c) SELECT (a,b,c) FROM request WHERE StatusID = 4

 

how can I correlate between same name fields in the tables ?

[Barand]

If the record formats are identical in both tables, the "all" syntax is

 

INSERT INTO proposal SELECT * FROM request WHERE StatusID = 4

[dflow]

the fields arent identical but most have same names , how would i make the same name fields inserted ?

[Barand]

See my original post

[dflow]

See my original post

i get an error

#1241 - Operand should contain 1 column(s)

INSERT INTO proposals (proposals.RequestID,
proposals.CustomerFirstName) SELECT (contact_form.RequestID,
contact_form.CustomerFirstName)   FROM contact_form WHERE StatusID = 2

[dflow]

bump

 

really intriged

[fenway]

Drop the parens around your select column list.