[Resolved] INSERT ... SELECT MySQL query prob

[perpetualshaun]

I'm trying to code a combination of the INSERT ... SELECT MySQL query, but ALSO add in a few values that I'm not selecting from the other table. Here's my query...

INSERT INTO pending_products (prod_no, prod_status, prod_created_on, prod_created_by_fname, prod_created_by_lname, prod_created_by_email)
SELECT prod_no, prod_status FROM import_products WHERE prod_no='TTTT'
, 'Bob', 'Jones', '[e-mail]'

I think I've pulled this off before but I can't remember how I did it. Any query gurus out there?

Thanks,

Shaun

[Roger_Ramjet]

Yes it can be done, if I get what you are trying to do

INSERT INTO pending_products (prod_no, prod_status, prod_created_on, prod_created_by_fname, prod_created_by_lname, prod_created_by_email)
SELECT prod_no, prod_status, 'Bob', 'Jones', '[e-mail]' FROM import_products WHERE prod_no='TTTT'

Except you are missing the prod_created_on data.