Re: Inserting multiple rows wtih a SELECt in the values clause

> "stan" == stan writes: stan> I suspect this may be because the SELECT in the values clause stan> returns multiple rows? Understand this: VALUES is really just a special form of SELECT that returns only the specific rows that you tell it to construct. Every single row returned by a VALUE

Inserting multiple rows wtih a SELECt in the values clause

OK, now that figured out how to return the constant, this is the final query I need to run. INSERT into rate ( employee_key , project_key , work_type_key , rate ) VALUES ( ( SELECT employee.employee_key , pr