update single row error
This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why?UPDATE property pSET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code...
View Answer
| Oct 20 2007 2:43 PM GMT
| asked by
Mandrews81
Update, multiple row query


